•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to list a column excluding certain cells based on content?
I'm trying to have excel return all the values in column B, except for those that start with "x " and those that are blank. I've tried playing around a bit with various IF, MATCH, FILTER and UNIQUE functions, but I think I'm missing one specific piece of knowledge to actually make it work. In the formula bar is my latest attempt, which I really thought would be IT, but as you can see, it was not.
I've typed in the begining for what I'd like the start of the final list to look like in column F, marked in green.
Thanks for any help!
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#financial modeling with spreadsheets
#rows.com
#AI formula generation techniques
#cloud-based spreadsheet applications
#Excel
#column
#values
#IF function
#MATCH
#FILTER
#UNIQUE
#blank
#exclude
#return
#cells
#content