•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Same filters more columns
I would like to understand whether, in Excel, it is possible to apply a filter across multiple columns.
For example, I need to select, across six columns, all codes that start with 45* in order to filter the records by row. I would like to avoid creating endless formulas in another column using the “OR” function, because there are many codes.
Does this possibility exist? Something like applying the same filter simultaneously to 6 columns.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#Excel compatibility
#Excel alternatives
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#row zero
#financial modeling with spreadsheets
#Excel
#filter
#multiple columns
#codes
#row
#formulas
#OR function
#simultaneously
#45*
#criteria
#records
#selection