marking duplicates between two files

[Guest]

I have two files with about 10,000 rows. Each one has a column that has
duplicates in each column so conditional formating does not help me find a
duplicate between the files. I would like to add a column where I can
indicate which values are duplicates between the two files. Access will not
work because there is no common link. I would like to have a value which
indicates which rows are duplicates so I can sort them and get them to the
top of the file.

 

[Tim879]

You can try the countif function as follows:

In file 1 add a formula in a blank column to be =countif($A$1:$A
$100,a1)

Modify the range to be what ever you need

Any value returned by countif > 1 is a duplicate.

 

[Guest]

thanks, I'll try that but will the count if also count the dulplicates
within the column? I really only want it to count between the two
spreadsheets.