=LARGE(A1:A3,1) would give FIRST highest digit
=LARGE(A1:A3,2) would give SECOND highest digit
=LARGE(A1:A3,3) would give THIRD highest digit
=SMALL would give the opposite
--
Pivotrend
------------------------------------------------------------------------
Pivotrend's Profile:
http://www.excelforum.com/member.php...fo&userid=4062
View this thread:
http://www.excelforum.com/showthread...hreadid=521549