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