Compare worksheets?

  • Thread starter Thread starter jah4ksu
  • Start date Start date
J

jah4ksu

Is there any way to compare one worksheet with another
worksheet to determine which cells have different values
between the two worksheets?

I have a worksheet full of names and addresses which I've
been updating regularly, but I just realized that there
is a duplicate copy on my other PC which I have also been
updating, thinking it was the same worksheet (long
story). How do I compare the two?
 
Hi Jah4ksu!

Here's a post from Bernie Deitrick to a similar question:

"With both workbooks open, in a cell next to your first address, type
=MATCH(
then click on the cell with the address, then type a comma, then
click on Window and select the entire column with addresses, then type
, False)
and press enter. Copy that formula down for as far as your addresses
exist.

Any formula returning an error means that the address doesn't exist in
the other database. Any formula returning a number shows the row in
the other workbook where its mate resides.

Repeat for the second workbook, and you are done."


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top