Formula - Evaluate for Double Count IF condition is met

[SteveOranjin]

Hello,

I am in the middle of writing a formula that evaluates whether or not a column has any duplicates in it. The problem is, is that I don't know how to make the formula evaluate duplicates where that condition is met.

If the header is "SKU" then I would like the formula to count the number of duplicates and return the number. So,

IF column C has header "SKU"
Then
Count numebr of duplicates.

If Column does NOT have "SKU" in title, than do not count duplicates.

Steve

 

[Eric W]

I'm not sure what to tell you. It works fine for me in multiple scenarios. Check that your range is correct. If one of the other columns has SKU as part of the heading, that could cause a problem. Change this line:

Set c = Headers.Find("SKU")

to

Set c = Headers.Find("SKU", lookat:=xlWhole)

and it will just look for the column that has "SKU" only in it.