Duplicate checker with Date Involved

[29sandesh]

Hi team, I am stuck and any help is highly appreciated. Have 3 columns as below. SKU id can be anything. I need help trying to have a formula for column C. If the SKU is used for first time column C should say NO . I tried =IF(COUNTIF(C:C,C2)=1,"No","Yes") but its not useful in this condition.

Order Date | SKUID | IS SKU ID REPEATED BEFORE THIS DATE
10 July | 10001 | NO
11 July | 10002 | NO
12 July | 10003 | NO
13 July | 10001 | YES
14 July | 10001 | YES
15 July | 10005 | NO
16 July | 10006 | NO
17 July | 10002 | YES

 

[Eric W]

Try this in C2 and copy down:

=IF(COUNTIF($B$1:$B1,B2),"YES","NO")

 

[JoeMo]

Try:

IF(COUNTIF(B$2:B2,B2)=1,"NO","YES")

 

[BenMiller]

Or =CHOOSE(ISNUMBER(MATCH(B2,$B$1:B1,0))+1,"No","Yes")

 

[29sandesh]

try:

if(countif(b$2:b2,b2)=1,"no","yes")

thanks this one worked, thanks everyone

 

[JoeMo]

You are welcome - thanks for the reply.