Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Using MAX to reference a row
I am trying to retrieve data associated with my maximum in one column. How
can I use the MAX function on column A to return the value in column B in the same row? For example, if "=MAX(A1:A1000)" returns 25.67 from cell A315, how do can I get a value from B315 returned? The row in which the maximum is found from column A is variable and this needs to be repeated many times, so a function is highly desireable. Thanks!! |
#2
|
|||
|
|||
Using MAX to reference a row
=INDEX(B1:B5,MATCH(MAX(A1:A5),A1:A5,0))
Adjust B1:B5 and A1:A5 to your situation -- Kind regards, Niek Otten "monty" wrote in message ... I am trying to retrieve data associated with my maximum in one column. How can I use the MAX function on column A to return the value in column B in the same row? For example, if "=MAX(A1:A1000)" returns 25.67 from cell A315, how do can I get a value from B315 returned? The row in which the maximum is found from column A is variable and this needs to be repeated many times, so a function is highly desireable. Thanks!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
a cell reference in a 3d reference | Excel Worksheet Functions | |||
Flexible Cell Reference | Excel Discussion (Misc queries) | |||
Absolute Worksheet reference number | Excel Discussion (Misc queries) | |||
Cell Reference Math | Excel Worksheet Functions |