can i use filters to compare data instead of vlookup?

G

Guest

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?
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting multiple memberships 1
in an Excel database, comparaison between two columns with "almost"the same names => how to search i 1
comparing lists of data to remove duplicate data 2
VBA: How can I use a string variable as autofilter criteria? 4
Value filter missing in pivot table 3
Compare two worksheets and identify common entries 3
VLOOKUP on Filtered Results? 2
URGENT - Merge/compare workbooks 8

Top