I have data in two columns (say A2:B20). To get what I want, I have to filter by the first column, and then get the maximum value in the second column of the filtered array. Can this be done without a custom function? If not, what would the custom function be?

1 Answer 1


The formula

 =MAX(FILTER(A:A, B:B="something"))

gives the maximum of the entries in the A column for which the corresponding entry in B column is "something". See documentation for FILTER.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.