finding duplicate data in multiple spreadsheets

[Robert Poole]

Does any one know a formula, script, or a macro which
checks through multiple excel files and searches for
identical entries.

 

[Tom Ogilvy]

Chip Pearson's page on duplicates has many methods/suggestions.

http://www.cpearson.com/excel/duplicat.htm

I suspect you could adapt some of them to work on multiple workbooks.