=LARGE(Sheet1!$A$1:$Z$1, 1)
=LARGE(Sheet1!$A$1:$Z$1, 2)
=LARGE(Sheet1!$A$1:$Z$1, 3)
=LARGE(Sheet1!$A$1:$Z$1, 4)
=LARGE(Sheet1!$A$1:$Z$1, 5)


"bob135" wrote:


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