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?

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.