Need help with a formula to look for unique combinations of 3 values from 3 diffrent

[Anon2000]

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!

[flesem25]

I'd create a new column D and set it to '=A&B&C' or maybe '=A&"-"&B&"-"&C' and then set conditional formatting on column D.

[XOR LX]

Hi,

Assuming your data is in A2:C10, enter this formula in D2 and copy down as required:

=IF(SUMPRODUCT(--($A$2:$A$10&$B$2:$B$10&$C$2:$C$10=A2&B2&C2))>1,"DUPLICATE","")

You can then filter on this new column for DUPLICATE (or apply some basic Conditional Formatting).

Regards