Microsoft Office Forums

Go Back   Microsoft Office Forums > >

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

Hello

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
  #2  
Old 08-09-2008, 08:34 PM
cweachter cweachter is offline
Novice
 
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
Reply

Thread Tools
Display Modes


Other Forums: Access Forums

All times are GMT -7. The time now is 01:31 AM.


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