Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have columns that have quite a bit a bit of data in them and some of the
numbers are the same.. I would like to be able to find the number that appears most often, then the second most appearing number and third, all the way to the fifth most appearing number. I have been able to use "MODE" to find the most often used number but have not be able to find out how to do the rest. Any help would be appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
transfering data in another column entering more sorted data | Excel Worksheet Functions | |||
Automatically refresh sorted data | Excel Discussion (Misc queries) | |||
Dependant Data Validation not sorted | Excel Worksheet Functions | |||
Trying to have data from one sheet to another sorted.... | Excel Discussion (Misc queries) | |||
Print sorted data | Excel Discussion (Misc queries) |