View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Pivotrend
 
Posts: n/a
Default Display largest of 3 numbers into 4rth cell


=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