I have a series of CSV files and I want to find duplicate entries on each of the CSVs.
So I want to find all entries (within any cell) who are in CSV#1 AND in CSV#9 (for example).
This list of duplicate entries could then be exported as a txt/csv/clipboard file.
I am unsure as whether this could be accomplished within Excel (for example a macro)...
Skills: microsoft excel, mysql administration, php, database programming, csv