Counting characters within a column....

[patt_the_ski]

I need a formula that will go through a series of invoices and seperate them by the text code within the invoice series. I have an example of column A1 "BC, BS, BA" are all contained within the numbers how go I keep a count of each?


200BC000000101
200BS000005201
200BA000000101
200BC000010201
200BC000010301
200BS000020601
200BA000018101
200BA000019201
200BS000093801
200BC000096301

 

[Pekkavee]

You could start with Data - Text to columns - and fixed lenght.
This way you can separate each series.

Pekka

 

[Aladin Akyurek]

for example:

=COUNTIF(Range,"*BS*")

maybe?