Comparing Databses

[xzmike]

I have two databases. Most of the entries are duplicates, but a few are not. I'd like to make a list of those that aren't duplicates. Sheet1 in the workbook has the few that aren't duplicates; Sheet2 is the shorter list; and Sheet3 is where I'd like to copy the non-duplicates (all the date on the row) to.

Headings are on row one, data starts on row two. The row goes form col A to col F. I want to compare on column B. Column B's title is "VIN#". I can name ranges if that makes it clearer.

 

[fairwinds]

Hi,

Try:

=ISNUMBER(MATCH(B2,Sheet1!B:B,0))

in a separate column, dragged down as far as your data goes. Then use autofilter and filter out all the FALSE and copy to your new sheet.