Apparently I'm not searching for the right term(s) online or there is a more common way of approaching this problem that I'm missing.

Basically I Have two separate single-sheet workbooks with street addresses and I need to isolate the duplicate addresses in the second workbook.

Workbook #1 has the relevant addresses in Column C, Workbook #2 has addresses in Column H. I need a formula that will isolate the duplicate addresses in wb#2.

3/7/2013 2:50:27 PM

Just do a vlookup or index/match statement.

So vlookup(address #2, workbook #1, 1, false).

This will give you a column next to your address #2's that have a match in workbook #1.

3/7/2013 2:54:44 PM

use the classic Unix diff command

now available via GnuWin32

3/7/2013 8:52:02 PM

yeah, that's a totally reasonable solution for someone at their leve

not

3/7/2013 8:53:22 PM

It actually wouldn't work at all because it would bring out fragments of the internal structure of the workbook; it's only really effective for CSV files, and I just felt like posting that for the laffz

3/8/2013 7:33:55 AM

diff would work assuming you had a flat text file. It's a little more trouble than it's worth. Vlookup would take a few seconds.

3/8/2013 9:17:04 AM