Frequency + Ranking Function.

[myteam]

How do I count the frequency and ranking these example number.

4463
5454
4463
2256
2251
2251
4463
3351
4463
5454
4463
2256
2251
2251
4463
3351
4463
5454
4463
2256
2251
2251
4463
3351
4463

and want result in colum B and C something like this,
2251 8
4463 4
3351 2
5454 1
2251 1
and so on....

Whole night search for code for this. Help me...

[NBVC]

Are those the actual true results you expect from this sampleset? If so, please explain how you get 8 for 2251 and then 1 for 2251?

[myteam]

Nope. That just a sample on how the answer should be...
Actually the list is much longer so I just put a sample on how the answer will look like.
Please help me...

[noexcel=badwork]

you can use the advanced filter to extract the unique values and paste in column B.
in column C use this formula:

Please Login or Register  to view this content.

copy down
attached the file

[myteam]

Hi, thanks for the frequency tips.

Is there a way where I don't need to copy the formula to each cell in column C since the unique number is hundred of number.

And is it possible to have them be ranked?

[noexcel=badwork]

here is another code where it will show cells as blank not zero if value is not existent

Please Login or Register  to view this content.

to rank them use filter

[DonkeyOte]

Why not just use a Pivot Table ?

Set the Number Field as both Row Field/Label & Data Field set to COUNT.
Order the results based on COUNT of number field (desc)

edit: sample (with dynamic source) attached