Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
Old 07-25-2008, 06:41 AM
leroytrolley leroytrolley is offline
Comparing Data
Join Date: Jul 2008
Posts: 11
leroytrolley is on a distinguished road
Default Comparing Data


I've got two long columns of addresses in two seperate worksheets. I need to be able to compare the two columns to find out if there are any addresses that are not included in BOTH columns.

Can this be done?
Reply With Quote
Old 08-09-2008, 08:34 PM
cweachter cweachter is offline
Join Date: Aug 2008
Posts: 2
cweachter is on a distinguished road
Smile comparing data

Try running a vlookup on one of the worksheets. Vlookup Column 1 of addresses and see if you get an error when you copy it down. I would first sort both in alphabetical order. This should give you an answer.
Reply With Quote

Thread Tools
Display Modes

Other Forums: Access Forums

All times are GMT -7. The time now is 08:56 PM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd. is not affiliated with Microsoft