Max (A1:A1), relating to other cells
 

Ive got Max A:A, which returns the maximum number in column A. How can i
get another cell to show the data from column B, which is pulled from
the same row as the result of Max A:A.




--
Mark


http://www.mozilla.com/firefox/ - Firefox Rules!
http://fireftp.mozdev.org/ - FTP Plugin for Firefox
http://ietab.mozdev.org/ - IE tab. Get Windows updates in Firefox

Max (A1:A1), relating to other cells
 

Try something like this:

=INDEX(B:B,MATCH(MAX(A:A),A:A,0))

Note: if there are duplicate MAX values, the formula returns the information
for the first MAX match in the list.

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"Mark Solesbury" wrote:

Ive got Max A:A, which returns the maximum number in column A. How can i
get another cell to show the data from column B, which is pulled from
the same row as the result of Max A:A.




--
Mark


http://www.mozilla.com/firefox/ - Firefox Rules!
http://fireftp.mozdev.org/ - FTP Plugin for Firefox
http://ietab.mozdev.org/ - IE tab. Get Windows updates in Firefox

Max (A1:A1), relating to other cells
 

Try this:

=VLOOKUP(MAX(A:A),A:B,2,0)

If you have two or more values that are equal to the maximum, this
will bring data from the first match found.

Hope this helps.

Pete

On Mar 30, 2:41 pm, Mark Solesbury
wrote:
Ive got Max A:A, which returns the maximum number in column A. How can i
get another cell to show the data from column B, which is pulled from
the same row as the result of Max A:A.

--
Mark

http://www.mozilla.com/firefox/- Firefox Rules!http://fireftp.mozdev.org/- FTP Plugin for Firefoxhttp://ietab.mozdev.org/- IE tab. Get Windows updates in Firefox