Range with blanks, count the string then automatically sorted by prequency

[Siahaan]

Hi all..
I have single column and multiple columns contain numeric data's with blank cells... I need to count the single string and sort them by occurances (frequency)..
for easy to understand here within this massage the attached. thanks for your help.

[samba_ravi]

IF THE NUMBER IS 789717 then the Frequency of 7 is 3 OR 1 in this case

[Siahaan]

@nflsales, thanks for your spot respon,,,considering the frequency of 7 in 789717 is 3. there is no dupli inside the cells in my data..
I'll be waiting for your reply then..thanks

[samba_ravi]

E17=LARGE(INDEX(COUNTIF($A$17:$C$25,{"*0*";"*1*";"*2*";"*3*";"*4*";"*5*";"*6*";"*7*";"*8*";"*9*"}),0),ROW($A1))

Please Login or Register  to view this content.

F17=MATCH(LARGE(INDEX(COUNTIF($A$17:$C$25,{"*0*";"*1*";"*2*";"*3*";"*4*";"*5*";"*6*";"*7*";"*8*";"*9*"})+1/ROW(A$1:A$10),0),ROW($A1)),INDEX(COUNTIF($A$17:$C$25,{"*0*";"*1*";"*2*";"*3*";"*4*";"*5*";"*6*";"*7*";"*8*";"*9*"})+1/ROW(A$1:A$10),0),0)-1

Please Login or Register  to view this content.

Note: It will work only if there is no duplicates numbers with in the number

[Siahaan]

well thanks again for your reply, but formula in E17=LARGE(INDEX(COUNTIF($A$17:$C$25,{"*0*";"*1*";"*2*";"*3*";"*4*";"*5*";"*6*";"*7*";"*8*";"*9*"}),0),ROW($A1)), almost same with formula =SUM(LEN(A$17:C$25)-LEN(SUBSTITUTE(A$17:C$25;F17;""))) (+CSE) then klick the short button.
I think you are close for what I'm looking for..Simply, can you change the result,,return the value that I want to count start from largest value in this case 7,0,6,8,9,1,5,2,3,4 in F17 down to F26. Not the number of number. The rsult will be counted using =SUM(LEN(A$17:C$25)-LEN(SUBSTITUTE(A$17:C$25;F17;""))) (+CSE) in E17 down to E26. Thankyou

[Siahaan]

self sorting.JPG
some like this

[Siahaan]

I've tried to post something but not sure what was wrong always failed, I just to try tell the forum that my problem is "solved" of course helped by nfsales formula..thank you.