1 min readfrom 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.

submitted by /u/d8gfdu89fdgfdu32432
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#rows.com