Comparing 2 lists and return missing values

[nickyedwards99]

I have two lists of company names. One list will keep getting updated and new names may appear. How can i identify any new names on the list? Do i need a macro or a v-lookup function?

 

[texasalynn]

using a vlookup anything with #N/A will indicate a new name

 

[nickyedwards99]

The lists are not next to each other. The one that gets updated has many repeated names. The other lists is a summary of them all. So i can't line up the lists and compare them. I'd need to highlight both ranges and do some sort of comparison to see what names appear in one list but not the other. Any suggestions?

 

[texasalynn]

yes we do that here. So we do a vlookup on both lists. It's ok if they are not on the same sheet and have duplicate names.

 

[andyjw]

Yeah

Vlookup will do it

Andy

 

[babycody]

Then use autofilter and filter for N/A. Select all of the cells you get from the filtered list, and hold down the Alt+; keys. This will let you select visible cells only. Copy and paste to another location if that's what you want.

 

[nickyedwards99]

Thanks for all of the advice, it's a big help.

 

[andyjw]

You will need to check N/A filter for duplicates before copying to your list

Andy