Forum

Notifications
Clear all

Filter for Multiple Values in a Column

3 Posts
3 Users
0 Reactions
75 Views
(@shauste)
Posts: 2
Active Member
Topic starter
 

Hi,

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?

Thanks

Stevie

 
Posted : 14/10/2021 4:51 pm
(@mynda)
Posts: 4761
Member Admin
 

Hi Stevie,

Welcome to our forum!

You can use Power Query to exclude a list of items from a list as explained here.

Mynda

 
Posted : 14/10/2021 7:25 pm
(@debaser)
Posts: 837
Member Moderator
 

You could also put those values into a column of cells and use that as criteria in an advanced filter.

 
Posted : 15/10/2021 4:58 am
Share: