Sorry, I forgot $ signs from COUNTIF, and of course you have to replace $9 to
the upper limit of your real range, e.g. $5672
=LARGE(A$1:A$9,COUNTIF(A$1:A$9,LARGE(A$1:A$9,1))+1 )
If you have more problems, please clarify them!
Regards,
Stefi
€˛Pivotrend€¯ ezt Ć*rta:
didnt work
i have thousands on numbers in one clomun
not just two
--
Pivotrend
------------------------------------------------------------------------
Pivotrend's Profile: http://www.excelforum.com/member.php...fo&userid=4062
View this thread: http://www.excelforum.com/showthread...hreadid=514745