•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Filter formula to pull rows from criteria of 2 columns
Our take
When working with filter formulas in spreadsheets, it’s essential to ensure that the criteria for multiple columns work together effectively. In your case, you want to create a filter that pulls all rows where both columns N and O have positive balances, giving you a concise list of work-in-progress (WIP) and unearned revenue. Your current formula seems to focus only on column N, due to the way the OR function is applied.
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
[link] [comments]
Read on the original site
Open the publisher's page for the full experience