Hi,
can someone help me with this, I am trying to find the duplicates in a Column C and if a duplicate is found then it needs to check for the Letter "a" (same row)in the Column A. If "a" is found then it needs to clear the dupicate value (In column C).

A B C
1
2
a 1
3
4
2 5
a 4


Thank you,