Hello,

I am trying to figure out a way to find common strings in multiple sheets and then give a list of the common strings found and how many times each one was found. What I need to have is .... Sheet1 has a list of part numbers in Column A for a given job. The list could have as many as 120 part numbers. This continues for each job in Sheet2, Sheet3 etc.

Let's say I start with 50 Sheets containing part numbers for a job. How can I find the common parts across all Sheets? And then give me a list of the common (or exact matches) found in more than 1 Sheet. Then tell me how many times it was found? Like it finds Part Number: "CA100-87" that was found on more than 1 Sheet and was found in 26 out of 50 Sheets.

I hope I am making sense for what I am asking for. Thank You for your time and help in advance!