Once again, the only way I can see to do this is with a UDF I've
installed, morefunc.

{=COUNTA(A1:A1000)-COUNTDIFF(A1:A1000&B1:B1000,,)}

Array entered.

If the answer is greater than zero, you have a duplicate. If the
answer is less than zero, you probably forgot to enter as array.