One of us has really missed the boat on this!

Biff

"Bob Phillips" wrote in message
...
=COUNTIF(Sheet2!A:A,A2)

and copy down

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"myra_deV" wrote in message
...
hi, i have the following problem

worksheet 1:
company number of industries
1000 ?
1010 ?
1020 ?

worksheet 2:
company industry
1000 2115
1000 2350
1000 2140
1010 3500
1010 3510

i would like to count per company the number of industry codes, differing
at
the first 2 digits.
so for company "1000" count would be 2. (21.. and 23..), but for "1010"
count would be only 1.
a normal countif function appears inappropriate, i tried


count(if(AND(company="1000";left(industry..;2)<le ft(industry..;2));industry
...)
but i excel stops once it has found the company in row 1.

thanx.