Value in cell adjacent to max of column

Giganews Newsgroups
Subject: Value in cell adjacent to max of column
Posted by:  dauclair (dauclair.28fe4q_1148665251.6969@excelforum-nospam.com)
Date: Fri, 26 May 2006

I want to be able to grab a value in a row adjacent to the maximum of
another column.  If the maximum value of column C was in row 30, I want
to be able to return the value of cell A30.

Any help would be greatly appreciated.

--
dauclair
------------------------------------------------------------------------
dauclair's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=34852
View this thread:http://www.excelforum.com/showthread.php?threadid=545973

Replies