Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I know that I can find the most common value in a group of numbers with MODE
function. But is this possible to find the second most common value in the same group of numbers. It mustn't be with the same function, I just want to get 3 most common values from one and the same group of numbers so that i dont have to delete any numbers. I mean not so that i find the most common value, delete all those values and then will get second most common value. No. I want all numbers to stay. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
I still cant get the six most common numbers to come up | Excel Discussion (Misc queries) | |||
How do I find the 6 most common | Excel Discussion (Misc queries) | |||
common log trendline | Excel Discussion (Misc queries) | |||
Common Private Sub | Excel Discussion (Misc queries) | |||
Common spacing | Excel Worksheet Functions |