•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to use max with filter
Our take
Are you frustrated with legacy spreadsheet formulas that hold you back from achieving your goals? If you want to filter data based on the maximum value between pairs of cells without creating a helper column, this guide is for you. By using the formula `=FILTER(A:A, MAX(A:A, B:B) = 1)`, you can efficiently identify the highest values across rows in real time. Read on to discover how to implement this formula effectively and streamline your data analysis process. Unlock the potential of your spreadsheets today!
=filter(A:A,max(A:A,B:B)=1)
I think what's happening is that it's taking the max of the entire column rather than max(A1,B1), max(A2,B2), and etc for each row. I want to avoid using a helper column where I calculate the max for each row and apply the filter on that instead.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience