Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have 3 columns of data:
Column E Column G Column J Bell, Charlie 48 .176 Davis, Johnny 34 .500 Smith, Tom 22 .335 Williams, Bill 56 .450 McElroy, Mike 62 .210 I want a formula that will identify the largest value in column J among all values in column G that are greater or equal to 48, and display the corresponding name from column E in the cell containing the formula. In this example, the answer is "Williams, Bill" because he has the highest value (.450) in column J among all rows that are 48 or more in column G. Can anyone help? Thanks, Bob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
2 IF Statements not mutually exclusive | Excel Discussion (Misc queries) | |||
Excel MS Query multiple select statements | Excel Discussion (Misc queries) | |||
UDFunctions and nested If-the-else statements | Excel Worksheet Functions | |||
Linking two IF statements together | Excel Discussion (Misc queries) | |||
Nested IF statements | Excel Worksheet Functions |