•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
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]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#Excel alternatives for data analysis
#AI formula generation techniques
#formula generator
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#Excel alternatives
#filter
#formula
#rows
#positive balance
#column N
#column O
#criteria
#Excel
#WIP
#unearned revenue
#concise list
#OR