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