look in Help index for LEFT and COUNTIF

--
Don Guillett
SalesAid Software

"cj21" wrote in message
...

An example best illustrates my problem:

I have a long column of product codes, like the following

01051110
01051190
01051900
01059100
01059900
01060010
01060020
01060030
01060090
02062200
02062900
02063000
02064100
02064900
03011000
03019100
03019200
03019300


As you can see products start 01 then go to 02 then 03. In practice
this continues-04,05 etc until i come to 09, then it changes to 11, 12,
13,..19 then changes again to 21, 22, 23,..29. It does this until 91,
92,...99.

I wish to count the number of 2-digit products and present them in a
table. For example there are, in this example, 9 products that begin
with 01, 5 products that begin 02, and 4 products that begin 04.

Is there a quick way of doing this?


--
cj21
------------------------------------------------------------------------
cj21's Profile:
http://www.excelforum.com/member.php...o&userid=25673
View this thread: http://www.excelforum.com/showthread...hreadid=482177