•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to use max with filter
=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]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#row zero
#rows.com
#Excel compatibility
#financial modeling with spreadsheets
#filter
#max
#helper column
#row
#Excel
#calculate
#max(A1,B1)
#max(A2,B2)
#entire column
#data processing
#array formula
#avoid
#apply