Filter data by multiple values

[gwoolley0302]

Hi, I have a set of data which I'm looking to filter by the value in one of the columns. That specific column contains ID numbers; there are hundreds of unique ID numbers each with hundreds of entries. I want to extract a table which only represents (for example) 100 of the 500 ID numbers. I have a table of these 100 ID numbers - how would I use this to quickly filter the large set of data? I can't see an option in the regular autofilter tool - is there a search & find type of formula I could use? Really appreciate any help. Thanks, Greg

 

[Fazza]

hi, Greg

If I understand correctly, easiest way might be with advanced filter - ALT-D-F. Excel help refers. Something like put the header for the field in row 1, the list of 100 ID numbers below that. If after a blank row or two you then have the full unfiltered dataset the advanced filter lets you copy the desired filtered results to another location on the same sheet.

Another way is using a query table - ALT-D-D-N and follow the wizard. This is a little more advanced. Basically a query using the two tables. In SQL it is like below

HTH. Regards, Fazza

SELECT A.*
FROM FullDataset A INNER JOIN ShortList B ON A.ID_field = B.ID_field

Or equally,

SELECT A.*
FROM FullDataset A, ShortList B
WHERE A.ID_field = B.ID_field

 

[gwoolley0302]

Thanks Fazza, appreciate it

 

[Fazza]

you're welcome, Greg