Compare one file to another

[Sandy]

I have 2 file which are similar, I want to find all the records from one that
exsist in the other.

EX John Doe is in both files, how can I tag them, or merge them or something.
Even just tagging them I could remove the ones that don't get tagged

 

[Dave Peterson]

Chip Pearson has lots of techniques for working with duplicates:
http://www.cpearson.com/excel/Duplicates.aspx

 

[Sandy]

that seems to be for a single list of data, I need to compare the same list
in 2 different file s

 

[Dave Peterson]

You can use a couple of formulas in helper columns:

=isnumber(match(a1,'sheet2'!a:a,0))
and drag down

Change Sheet2 to the other worksheet name.

If it's in different workbooks:
=isnumber(match(a1,'[workbook name here.xls]Sheet1'!$A:$A,0))

 

[Sandy]

I tried this, but I must be doing something wrong, Not sure what the !$O2:$O2,0
is suppose to be or do
M2 is the cell I am comparing in this file to O2 in the other file, I would
expect it to return a true since they do match


=ISTEXT(MATCH(M2,'[File 1.xls]_36___Buckeye_Council'!$O2:$O2,0))

You can use a couple of formulas in helper columns:

=isnumber(match(a1,'sheet2'!a:a,0))
and drag down

Change Sheet2 to the other worksheet name.

If it's in different workbooks:
=isnumber(match(a1,'[workbook name here.xls]Sheet1'!$A:$A,0))

that seems to be for a single list of data, I need to compare the same list
in 2 different file s

 

[Dave Peterson]

Your formula is using =istext(). I suggested =isnumber().

And you're comparing M2 to the single cell O2. I would think you would want to
compare the value in M2 to the entire O column:

=ISnumber(MATCH(M2,'[File 1.xls]_36___Buckeye_Council'!$O:$O,0))

If you really wanted to compare a single cell to a single cell, just do a simple
comparison:

=m2='[File 1.xls]_36___Buckeye_Council'!$O2

I tried this, but I must be doing something wrong, Not sure what the !$O2:$O2,0
is suppose to be or do
M2 is the cell I am comparing in this file to O2 in the other file, I would
expect it to return a true since they do match

=ISTEXT(MATCH(M2,'[File 1.xls]_36___Buckeye_Council'!$O2:$O2,0))

You can use a couple of formulas in helper columns:

=isnumber(match(a1,'sheet2'!a:a,0))
and drag down

Change Sheet2 to the other worksheet name.

If it's in different workbooks:
=isnumber(match(a1,'[workbook name here.xls]Sheet1'!$A:$A,0))

that seems to be for a single list of data, I need to compare the same list
in 2 different file s

:

Chip Pearson has lots of techniques for working with duplicates:
http://www.cpearson.com/excel/Duplicates.aspx

Sandy wrote:

I have 2 file which are similar, I want to find all the records from one that
exsist in the other.

EX John Doe is in both files, how can I tag them, or merge them or something.
Even just tagging them I could remove the ones that don't get tagged