•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to filter based on numbers I don't want to see
I have a list of product numbers and I want to filter out the numbers I don't need.
I wanted to filter out every product number that started with the number 5 by using "!5" in the filter bar but Excel doesn't recoqnize this. Is there something else I can write in the search bar instead of using a formula?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#rows.com
#AI formula generation techniques
#financial modeling with spreadsheets
#formula generator
#cloud-based spreadsheet applications
#filter
#Excel
#product numbers
#exclude
#filter bar
#search bar
#numbers
#formula
#list
#function
#criteria
#input