View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
bentor bentor is offline
external usenet poster
 
Posts: 2
Default Top 5 most recurrent values in range.

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