Hi
If your data is in A2 to A16, in cell B2 type

= countif($A$2:$A$16,A2)

Fill this formula down. This will count the occurance of each item in
your list. Now sort using column B.
regards
Paul

On Nov 28, 10:07*am, bentor wrote:
Hello Everyone,

I looking for the way to get top 5 most reccurent values in range/
column and sort it descending.

For example, I've got values:

apple
dog
dog
pig
apple
flower
sweet
door
apple
apple
pink
drink
door
swim
drink

What I would like to do is get top 5:
1. Apple - 4 times
2. dog - 2 times
3. door - *2 times
4. drink - 2 times
5. flower - 1 time

If you have any ideas please let mi know.

Best regards,
Bartosz D³ugokêcki