Second Most Common Value
Try this...
Numbers in the range A2:A11
B2 = mode formula: =MODE(A2:A11)
Enter this array formula** in B3 and copy down as needed:
=MODE(IF(COUNTIF(B$2:B2,A$2:A$11)=0,A$2:A$11+{0,0} ))
** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)
--
Biff
Microsoft Excel MVP
"Skalp" wrote in message
...
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.
|