Is there a way to compare two excel files for repetitious cells?

[Guest]

I am trying to find a way to compare two excel files in order to find
duplicate numbers between the two files. I am listing serial numbers and need
to make sure that there are no duplicates listed between more than one Excel
file.

Thanks

 

[darkwood]

If there was a formula or auto lookup that could do this, I would b
very interested as well. The only way I have done this is to create
third sheet and merge the two documents into one,(provided both file
have the same format) but color coding one document before merging, an
then sorting by the column that I want to look for duplicate values of.
This isn't really effective if you have more than 500 rows however, bu
it gets the job done if you are working with smaller size files