Put this in A5
=MAX(A2:A4)+LARGE(A2:A4,2)
and then copy to columns B and C.
Note: the 2 in the LARGE function denotes the second largest number.
You
can put 3 for the third largest, 4 for the fourth largest...
--
mphell0
------------------------------------------------------------------------
mphell0's Profile:
http://www.excelforum.com/member.php...o&userid=30153
View this thread:
http://www.excelforum.com/showthread...hreadid=537826