How to filter list from pre-existing list

[mrwawa]

Hi all,

I have a list of names with codes and a smaller subset of just codes.
How can I filter the larger list of names w/ codes from the subset
list, in order to transfer the names from the larger list to the
subset? I have tried the advanced filter option, but it wants to look
at individual cells. Do I need a macro that will cycle through the
subset and compare it to the master list?

Thanks,
Wade

 

[Dave Peterson]

Debra Dalgleish explains data|Filter|advanced filter with a criteria list.
http://contextures.com/xladvfilter02.html

Another way that I sometimes use is to put the subset list on a different
worksheet (say Sheet2) and put that list in A1:A###.

Then I use a helper column with a formula that returns True if my data is in
that subset list.

Say the data was in column B, I'd insert a new column C and use:

=isnumber(match(b2,sheet2!a:a,0))

Then I could drag that formula down and filter to show the True's.