Comparing 2 lists and return missing values

nickyedwards99

New Member
Joined
Sep 7, 2006
Messages
3
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?
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
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?
 
Upvote 0
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.
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,218,576
Messages
6,143,314
Members
450,477
Latest member
teresab543

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top