Help with an IF formula

[BMR]

I have a spreadsheet of approximately 20,000 rows and 50 columns. In Column C I have a list of SKUs that look like the following.


10001
10001B1
10001B2
100001B3
100002
100003
100003B1
100003B2
100003B3
100003B4

and so on. The B1,B2, etc are for additional boxes. The highest it goes up to is B7.

In Column J, I am numbering rows with a SKU with B_ in Column C with a 0, and leaving the others blank. I would like to have a formula that can do this for me.

So if in Column C, Row 72, there is a 70001B2, I want that same row in Column J to have a 0. If there is a 700003, I want that same row in Column J to be blank.

Can anyone help?

 

[BMR]

bump - please help a noob

 

[BMR]

anyone?

 

[taurean]

Supposing your data starts in C2 in J2 type in this formula:
=IF(ISNUMBER(FIND("B",C2,1)),0,"")
Is this what you are after?