Hole Numbers.xlsx
I have multiple worksheets in a workbook and need to identify if a value in a range of cells is duplictaed in any of the other worksheets. I have attached sample workbook.
If the hole numbers in Column B are duplicatd in any of the other worksheets in this workbook I want the worksheet name and/or cell reference to appear in column C, or flagged in some way if referencing is not possible.
This rule needs to apply to all worksheets...ie: if a number is duplicated in Worksheet 3 and 4. I need to flag it somehow.
The Workbook will eventuall have 64 worksheets and I need to identify if the hole number is duplicated anywhere within the workbook.
Can you please suggest a formula?
Bookmarks