Hey,
I am looking for a formula to check if a combination of 3 values is unique, i have a excel file with around 10.000 rows. I want to make sure if the combination of A + B + C is Unique
Example
Column A Column B Column C
10291323 1517247478 1
10291323 1517247478 2
10291323 1517247478 3
12475798 1867400930 1
12475798 1867400930 2
12907374 1124674667 1
12907374 1124674667 2
12907374 1124674667 3
12907374 1124674667 4
Now what i want is to make sure the combination of A + B + C is unique in the workbook for every row. And if there was a duplicate it would turn red or something to make sure i know its a duplicate.
I have been trying to do this myself but with my own limited excel knowledge i cant seem to find a solution
I really hope you can help with this problem,
Thanks!
Bookmarks