That is just to return an index into the large function. ROW(A1) returns 1,
so you get the first largest. When you copy down to the second row, this is
updated to ROW(A2), which returns 2, so you get the second largest.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"owl527" wrote in
message ...

it works perfectly fine! thank you....
But, what does ROW(A1) do? I don't understand why you put it in the
formula. Please can you explain? thanks.


--
owl527
------------------------------------------------------------------------
owl527's Profile:
http://www.excelforum.com/member.php...o&userid=20916
View this thread: http://www.excelforum.com/showthread...hreadid=499654