•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Filter function with multiple criteria and condition - Dynamic template
Expectation:
- )IF the direction is BUYS, the array should return 3 rows (excluding SELLS). IF the direction is SELLS, the array should return 4 rows. How to remove that "SELLS" under BUYS array or vice versa.
I AM HAVING HARDTIME TO GET THE CORRECT LOGIC HUHUHU! THANK YOU TO EVERYONE WHO CAN HELP!!
EDIT1: Replaced with correct image. Sorry for the confusion. Question is how can I create a dynamic formula so I can use if the conditions have 2 or more?
EDIT2: THANK YOU @Basic_Complaint8164
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#Excel alternatives for data analysis
#financial modeling with spreadsheets
#natural language processing for spreadsheets
#AI formula generation techniques
#generative AI for data analysis
#Excel compatibility
#formula generator
#Excel alternatives
#filter function
#BUYS
#SELLS
#dynamic template
#direction
#array
#dynamic formula
#criteria
#rows
#conditions
#logic