October 14, 2021
I'm trying to figure out how to search/filter for multiple values in a column. As an example, I'm trying to filter my worksheet for these values: 32216,32223,32224,32225,32228,32253,32254,32255,32272,32305,32311,32312,32348,32352,32353,32354,32377,32378,32385,32392,32406,32407,32505,32506,32520,32521,32522,32527,32528,32529,32610,32611,32612,32613,32614,32628,32726,32731,32734,32735,32736,32738,32739
My columns are filtered and I know that I can check each one individually, but there are over 1100 rows.
Is there a formula or some other tactic to use?
July 16, 2010
Welcome to our forum!
You can use Power Query to exclude a list of items from a list as explained here.