Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to filter list from pre-existing list
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to filter list from pre-existing list
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. mrwawa wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advanced filter and a list | New Users to Excel | |||
Filter the results of a list based on a previous vlookup against the same list | Excel Worksheet Functions | |||
Delete rows based on multiple criterias | Excel Discussion (Misc queries) | |||
Long list of words to find with Filter | Excel Discussion (Misc queries) | |||
Creating a list from an existing list. | Excel Worksheet Functions |