Hi folks
I have a column (B1:B100) containing alpha numeric product codes in the format of MJX 8/L/5-6 and MJC132/44/8-11 (the numbers vary).
The codes are always prefixed with MJX or MJC and I want to count how many of each type.
At present I am using =LEFT(B1,3) in column C to extract the first three letters.
Then in B102 =COUNTIF(C1:C100,”MJX”) for the total MJX
Can I combine the two steps in one formula so I can eliminate the unnecessary column C
I have a column (B1:B100) containing alpha numeric product codes in the format of MJX 8/L/5-6 and MJC132/44/8-11 (the numbers vary).
The codes are always prefixed with MJX or MJC and I want to count how many of each type.
At present I am using =LEFT(B1,3) in column C to extract the first three letters.
Then in B102 =COUNTIF(C1:C100,”MJX”) for the total MJX
Can I combine the two steps in one formula so I can eliminate the unnecessary column C