| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMPRODUCT or SUMIF if any values in a range equal any values in another range | Excel Worksheet Functions | |||
| count a word recurrent in many cells | Excel Worksheet Functions | |||
| How to stop a recurrent circular reference error message ? | Excel Discussion (Misc queries) | |||
| Recurrent error: disconnection from clients | Excel Programming | |||
| Search/Filter to find values in another range based on two cell values | Excel Programming | |||
Threaded Mode
