Forum Discussion
Matching values and return max of adjacent column
I'm looking to create a formula in Column J that would match values in Column K and return the largest corresponding number in Column H for the matched values. In the attached, K2 and K3 match, s...
That could be
=AGGREGATE(14,6,1/(COUNTIF($K$2:$K$10,$K$2:$K$10)>1)*$H$2:$H$10,1)
Please see in attached