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
|