Thank you for the reply. What formula would be used in the helper column?
Filter based on a list
I have a large data set with sku numbers in rows and many other info about each sku. I also have a specific list of skus that I need to view and edit info. I would like to filter to only show the rows with the skus on my list without having to input each sku individually into the filter. How can I filter based on a specific list of skus?
Answers
-
One way to do this would be to add a new sheet containing the SKU's you wish to filter by. Then in the original list add a new helper column with a formula to check whether the value on the current row is on the new sheet.
You should then be able to filter on the existing sheet using the new helper column.
If you want to give this a try and have any issues, please let me know, I would be happy to help further or even share screens to do so.
Thanks,
John -
Thank you for the reply. What formula would be used in the helper column?
-
This is the formula I tried but is came back unparseable. The master sku list column is named Sku and the search list is named Search Shotlist.
=IF(CONTAINS({Search Shotlist Range 1},[Sku]:[Sku])"True", ["False"])
-
Use a
COUNTIF
formula in a helper column to filter rows matching your SKU list
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.8K Get Help
- 429 Global Discussions
- 146 Industry Talk
- 485 Announcements
- 5.1K Ideas & Feature Requests
- 87 Brandfolder
- 151 Just for fun
- 73 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 37 Webinars
- 7.3K Forum Archives