marking duplicates between two files

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
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.
 
Back
Top