1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Filter formula to pull rows from criteria of 2 columns

I’m not sure if this is worded correctly. I don’t want the too columns to be conditional and cancel each other out. I want a filter list for all the rows that contain a positive balance in column N and column O in the same list.

This would give me a concise list of WIP an unearned revenue.

Edit: I feel like the answer is so simple and but it’s turning my brain into a pretzel. My current formula is as follows:

=FILTER(A6:R348, (N6:N348>0)*OR(O6:O348>0),”None”)

It only returns the rows that match the N column

submitted by /u/Straighty180-
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#rows.com