Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
can i use filters to compare data instead of vlookup?
I have to compare membership lists to identify if customers belong to certain
groups. Currently, I have been using Vlookup but I notice that there are too many nuisances. Could I use a filter to compare two membership lists and give me a more accurate answer? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
can i use filters to compare data instead of vlookup?
Maybe try setting up a new sheet with List1, and entering a new column
indicating List1 in each row......then adding List 2 at the bottom and entering List2 in the new column for each row in that section............then do Data Filter AutoFilter and check the arrows at the tops of the columns to filter from there........it may do what you're looking for......... Vaya con Dios, Chuck, CABGx3 "Vindell" wrote: I have to compare membership lists to identify if customers belong to certain groups. Currently, I have been using Vlookup but I notice that there are too many nuisances. Could I use a filter to compare two membership lists and give me a more accurate answer? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare month to month data | Excel Worksheet Functions | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
How do I compare data from 2 worksheets to find duplicate entries | Excel Discussion (Misc queries) | |||
Table Array in VLOOKUP Relies on Data Validation | Excel Worksheet Functions |