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

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

nickyedwards99

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

Well-known Member
Joined
May 19, 2002
Messages
8,458
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

Board Regular
Joined
Apr 3, 2006
Messages
74

ADVERTISEMENT

Yeah

Vlookup will do it

Andy
 

babycody

Well-known Member
Joined
Jul 8, 2003
Messages
1,395
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.
 

andyjw

Board Regular
Joined
Apr 3, 2006
Messages
74
You will need to check N/A filter for duplicates before copying to your list

Andy
 

Watch MrExcel Video

Forum statistics

Threads
1,129,553
Messages
5,636,982
Members
416,953
Latest member
broexc

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
Top