![]() |
#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. |
|
![]() |
||||
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 |
![]() |
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 |
![]() |
ReviTULize | Excel | 1 | 03-28-2013 02:27 AM |