Conditional format help

[khollibygolli]

I am trying to highlight duplicates of column C that are SKU product codes on Google Sheets. I currently have =COUNTIF($C$3:C3,C3)>1
My SKUs are 9 characters long but I only want the format to highlight if the 6th-9th characters are a match is this possible?

 

[ChrisFoster]

Try:

=COUNTIFS($C$3:C3,C3,LEFT($C$3:C3,5)&RIGHT($C$3:C3,4),LEFT(C3,5)&RIGHT(C3,4))>1

 

[Fluff]

You cannot use Left & Right in countifs like that.

 

[ChrisFoster]

You cannot use Left & Right in countifs like that.

What about;

=COUNTIFS($C$3:C3,C3,MID($C$3:C3,6,4),MID(C3,6,4))>1

 

[Joe4]

What about;

=COUNTIFS($C$3:C3,C3,MID($C$3:C3,6,4),MID(C3,6,4))>1

That is not valid either.
Please test your solutions and try your formulas before posting them!
Excel will tell you pretty quickly that it is not a valid formula.

 

[Joe4]

Try this formula:

=SUMPRODUCT(--(MID(C$3:C3,6,4)=MID(C3,6,4)))>1

 

[khollibygolli]

Try:

=COUNTIFS($C$3:C3,C3,LEFT($C$3:C3,5)&RIGHT($C$3:C3,4),LEFT(C3,5)&RIGHT(C3,4))>1

What about;

=COUNTIFS($C$3:C3,C3,MID($C$3:C3,6,4),MID(C3,6,4))>1

Didn't work but thanks for trying!

 

[Joe4]

Didn't work but thanks for trying!

Take a look at the formula I posted for you just before your last reply.

 

[khollibygolli]

Try this formula:

=SUMPRODUCT(--(MID(C$3:C3,6,4)=MID(C3,6,4)))>1

It didn't work for me . Just made all my blank spaces highlighted

 

[ChrisFoster]

That is not valid either.
Please test your solutions and try your formulas before posting them!
Excel will tell you pretty quickly that it is not a valid formula.

Ok fair enough, sorry.