max number repeated

  • Thread starter Thread starter Pivotrend
  • Start date Start date
P

Pivotrend

sup pros

i have many numbers in rows & columns

i want to find out the max number repeated in these set of rows
columns
then the second max number repeated
then the 3rd max number repeated & so o
 
Are you talking about MODE()?

=MODE(A1:A100)

Returns the most frequently occurring number.

If you want the second or third or whatever most used number, enter which
occurrence you're looking for into B1, and try this:

=INDEX(A1:A100,MATCH(LARGE(FREQUENCY(A1:A100,A1:A100),B1),FREQUENCY(A1:A100,
A1:A100),0))
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 
If it's not working correctly for you, watch out for "word wrap".

You could try keying it in yourself.
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

in message
=INDEX(A1:A100,MATCH(LARGE(FREQUENCY(A1:A100,A1:A100),B1),FREQUENCY(A1:A100,
A1:A100),0))
Click to expand...

thanx dude but can you correct this formula
 
Back
Top