Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Relating cells | Excel Worksheet Functions | |||
Relating fields | Excel Discussion (Misc queries) | |||
Relating text to a value | Excel Worksheet Functions | |||
Relating text to a value | Excel Worksheet Functions | |||
Problem with an "if" relating to a range | Excel Worksheet Functions |