![]() |
|
#2
|
|||
|
|||
|
You can in case the max value in column A is unique. When not, then you need some additional condition to determine, which row with e.g. 157 in column A must be returned!
When all values in column A are unique, then one possible solution: =INDEX($B$1:$B$300,MATCH(MAX($A$1:$A$300),$A$1:$A$ 300,0)) to return matching entry in column B. When the max value is not unique, the data from 1st row having max value in column A is returned; In case entry in e.g. column B is always numeric, another option will be also available: =SUMIFS($B$1:$B$300,$A$1:$A$300,MAX($A$1:$A$300)) When the max value is not unique, the sum of matching values in column B is returned. |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Return as many Y as the number of occurrence of values in another column | Marcia | Excel | 2 | 11-27-2020 04:19 PM |
| Formula to check combinations of values in one column to find match from another column | kong1802 | Excel | 1 | 06-15-2018 05:26 AM |
SumIfs not able to get two values from the same column..
|
LearnerExcel | Excel | 1 | 01-04-2017 02:32 PM |
| copy non zero values to new column | Guloluseus | Excel | 3 | 01-10-2016 08:48 AM |
Auto-create row from column values
|
ReviTULize | Excel | 1 | 03-28-2013 02:27 AM |