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"
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 |