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 on


--
Pivotrend
------------------------------------------------------------------------
Pivotrend's Profile: http://www.excelforum.com/member.php...fo&userid=4062
View this thread: http://www.excelforum.com/showthread...hreadid=495575

Check out Tools DataAnalysis Histogram..........

Vaya con Dios.
Chuck, CABGx3




"Pivotrend" wrote:


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 on


--
Pivotrend
------------------------------------------------------------------------
Pivotrend's Profile: http://www.excelforum.com/member.php...fo&userid=4062
View this thread: http://www.excelforum.com/showthread...hreadid=495575

max # repeated


--
Pivotrend
------------------------------------------------------------------------
Pivotrend's Profile: http://www.excelforum.com/member.php...fo&userid=4062
View this thread: http://www.excelforum.com/showthread...hreadid=495575

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:A1 00),B1),FREQUENCY(A1:A100,
A1:A100),0))
--
HTH,

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



"Pivotrend" wrote
in message ...

max # repeated


--
Pivotrend
------------------------------------------------------------------------
Pivotrend's Profile:
http://www.excelforum.com/member.php...fo&userid=4062
View this thread: http://www.excelforum.com/showthread...hreadid=495575

RagDyer Wrote:

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


thanx dude but can you correct this formula


--
Pivotrend
------------------------------------------------------------------------
Pivotrend's Profile: http://www.excelforum.com/member.php...fo&userid=4062
View this thread: http://www.excelforum.com/showthread...hreadid=495575

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 !
----------------------------------------------------------------------------
-------------------

"Pivotrend" wrote
in message ...

RagDyer Wrote:


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


thanx dude but can you correct this formula


--
Pivotrend
------------------------------------------------------------------------
Pivotrend's Profile:
http://www.excelforum.com/member.php...fo&userid=4062
View this thread: http://www.excelforum.com/showthread...hreadid=495575