How do you find the 1st, 2nd, .... nth highest value of a given row or
column of cells filled with numbers? Say I have a bunch of numbers in
A1 through Z1. I want the biggest 5 to appear on another sheet as A1,
A2, A3, A4, and A5.


--
bob135
------------------------------------------------------------------------
bob135's Profile: http://www.excelforum.com/member.php...o&userid=33388
View this thread: http://www.excelforum.com/showthread...hreadid=532137