Thank You very much, it works! And with that I can find the third most common
number too! It was really helpful!


"T. Valko" wrote:

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.