Hi,
Thanks for all the help in the past.
Here's today's question.
We have a long list of items in column C and they should all be unique numbers, but sometimes we make mistakes and have a duplicate number there. Is there a formula that will constantly monitor column C and flag with conditional formatting (or anyway possible) any item which is the duplicate of another in that same column?
Example:
Column C
Row 2: ES12-0111-A1
Row 3: ES12-3514-A1
Row 4: ES18-0111-A1
Row 5: ES12-0116-A1
Row 6: ES12-0111-A1
Row 7: ES12-2397-A1
Row 2 and Row 6 are the same and both need to be flagged in some way.
It would be ideal if all items in column C were colored black except any ones that have a duplicate and those are colored red. If there is more than one pair of duplicates, it's OK if they're all colored red, we can sort that out on our own. (There won't be a lot of duplicates.)
Thanks!
Bookmarks