1 min readfrom 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.

submitted by /u/Ok-Bandicoot-9357
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

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