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?
Google-sheets – How to compute the maximum of Column B after having filtered by the contents of Column A
google sheets
Related Topic
- Google Sheets – Concatenate Data from Multiple Columns
- Google-sheets – Comparing values in two different columns, detecting those that are also present in the second
- Google-sheets – Columns populated with the number of times each row has the first, second or third largest value for any given column
- Google Sheets – Solve Errors in FILTER Functions within Array Brackets
- Google Sheets – Find Last Value in Column Populated by ARRAYFORMULA
- Google-sheets – How to dynamically layout a columns cells based on a formula
- Google Sheets – How to Count Filtered Data When Using Slicer
Best Answer
The formula
gives the maximum of the entries in the A column for which the corresponding entry in B column is "something". See documentation for
FILTER
.