| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rank/Large Help
Hello
I have a list of randomly repeating values in A1:A100. I would like a formula in B1:B10 that will return the top 10 used entries in the list in order of use highest to lowest. It is possible that there may be less than 10 used entries and in that case I would like a 0. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LARGE / RANK FORMULA ERROR | Excel Discussion (Misc queries) | |||
| Having Trouble with the RANK Function...Try LARGE or SMALL Functio | Excel Worksheet Functions | |||
| RANK, duplicate ranking but no gaps in rank | Excel Worksheet Functions | |||
| Rank where lowest value is highest rank | Excel Worksheet Functions | |||
| Rank items, select one start date, have remaining dates follow based on rank | Excel Discussion (Misc queries) | |||
Threaded Mode
