try in column c : [VBA]=SUMPRODUCT(--($A$1:$A$14&$B$1:$B$14=A1&B1))[/VBA]It should return 1 for unique combinations and 2 (or more) for non unique.
I could also write code but this is more flexible as you "could" incorporate this into conditional formatting or even use in true data validation.