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