•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Formula for Returning Values Based On Guideline
Hi,
Say I have a column 1 where some rows have values like "ABC (XYZ)" and "ABC", and also other rows that are blank. I would like to return a value in column 2 each time column 1 only shows "ABC", but ignore the rows that are completely blank. Is there a formula for this? Thanks.
EDIT: It turned out what I needed was a lot more complicated than I originally thought, making my question no longer applicable. Thanks to everyone who responded.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#AI formula generation techniques
#generative AI for data analysis
#Excel compatibility
#real-time data collaboration
#cloud-based spreadsheet applications
#formula
#column
#value
#ABC
#rows
#blank
#return
#XYZ
#complicated
#question
#guideline
#ignore