Forum Discussion
Highlight Duplicate values across multiple sheets
I have a spreadsheet with an exhaustive list of names (ALL NAMES). I then have several other sheets (Silver, Gold, Top, Art, Music, Latin, Key) that have the names of various award recipients (a ...
Thank you for your response - it doesn't appear to be doing anything
It works for me in a small test workbook. Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
HansVogelaar The formula worked just fine for me! You just have to remember to close with 3 parentheses at the end of it and select a format to highlight or otherwise distinguish your data.
