=3+MATCH(MAX(C4:C75),C4:C75,0)
will give the row
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"owl527" wrote in
message ...
Hi, I am trying to find the cell location of the largest number in a
colume. I put: =ROW(LARGE(C4:C75, 1))
it keeps saying my formula contains an error, what function can I use
to find out the cell location ? please let me know. Thanks.
--
owl527
------------------------------------------------------------------------
owl527's Profile:
http://www.excelforum.com/member.php...o&userid=20916
View this thread: http://www.excelforum.com/showthread...hreadid=499654