Originally Posted by tomandbeth
Thank you. I thought this exercise would be "easy".
I have some old school, semi-manual ways I've done this using dos commands to "print" a directory file list to a text file that can be parsed in Excel, and then use IF/THEN functions to check for duplications and flag them. It can be done for all files, specific directories and subdirectories, and/or specific file extensions. PM me if you'd like me to walk you through it over the phone. It's a little late tonight, and I have a family commitment after work tomorrow, but I can find the time sometime over the next few days.
Note this is just for duplicate filenames, but it would allow you to find the same name with different extensions. I've not done this for metadata.
There are probably some ways to automate this type of task that I'm not aware of, but I know this will work.