Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
conditional MAX associated row data
I am struggling with the following MS-Excel formula. In the data that
follows I want to retrieve the NAME of the person who achieved the highest test SCORE where the DIFFICULTY rating exceeded 60. From the data below, I would expect to receive the name "Nate" from the 5th row. NAME DIFFICULTY SCORE Nate 55 78 Sara 62 77 Sara 58 79 Nate 64 79 Sara 59 84 I've discovered that I can retrieve the relevant score (79) with the following formula, but the same does not work for retreiving the text value in column A. When I convert the formula to return column A instead of C, I get the value "0" instead of "Nate." =MAX(IF($B$2:$B$999960,$C$2:$C$9999)) /* enter formula then press shift_control_enter */ Thanks for any help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need help with conditional data | Excel Worksheet Functions | |||
Conditional Data Validation | Excel Worksheet Functions | |||
Conditional data | Excel Worksheet Functions | |||
conditional data validation | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |