Mark Only First Occurrence of Duplicate values with multiple conditions

[amolvijay]

Hi Experts
I am working on a large data set, where in Column A and Column B have duplicate values. Rows almost flow to 35000 rows.
I wish to have a value in Column C, which will mark only first occurrence among duplicate value, rest being marked as "-".

Please help to create a formula which can get values in Column "C"

Column A	Column B	Column C
2jEAA	Template 0	Unique
8YEAQ	Template 1	Unique
8YEAQ	Template 1	-
A9EAI	Template 2	Unique
BHEAY	Template 3	Unique
FYEAY	Template 1	Unique
HeEAI	Template 1	Unique
HeEAI	Template 2	Unique
IwEAI	Template 3	-
J1EAI	Template 4	Unique
M0EAI	Template 5	Unique
OuEAI	Template 6	Unique
RAEAY	Template 7	Unique
rmEAA	Template 8	Unique
SIEAY	Template 10	Unique
SIEAY	Template 10	-
t9EAA	Template 1	Unique
uHEAQ	Template 2	Unique
v5EAA	Template 3	Unique
veEAA	Template 4	Unique
vUEAQ	Template 15	Unique
vUEAQ	Template 15	-
vUEAQ	Template 15	-
vUEAQ	Template 18	Unique

 

[Fluff]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

How about

=IF(COUNTIFS(A$2:A2,A2,B$2:B2,B2)=1,"Unique","-")