software

data that i have is

a b c d
jh address telephone number
ar address telephone number
address telephone number

ar address telephone number

column a needs needs number 1,2,3,4,5, etc.
but only if column be is jh or ar
and they need to be consecutive like you use with autofill numbering
but it needs to skip the spaces and yet keep the numbering in order

Gary Reger wrote...
gt;data that i have is
gt;
gt; a b c d
gt; jh address telephone number
gt; ar address telephone number
gt; address telephone number
gt;
gt; ar address telephone number
gt;
gt;column a needs needs number 1,2,3,4,5, etc.
gt;but only if column be is jh or ar
gt;and they need to be consecutive like you use with autofill numbering
gt;but it needs to skip the spaces and yet keep the numbering in order

If your topmost row is in row 1, so the topmost col A cell would be A1,
then try these formulas.

A1:
=IF(OR(B1={quot;jhquot;,quot;arquot;}),1,quot;quot;)

A2:
=IF(OR(B2={quot;jhquot;,quot;arquot;}),1 MAX(A$1:A1),quot;quot;)

Fill A2 down as far as needed.it did not work here is what i got

1JH
1JH
1AR
1AR
1JH
1JH
1JH
2AR
2JH
2JH
2JH
2JH
2JH

AR

AR

3JH
3AR4JH4JH
4JH
4JH
JH
AR

5AR
5JH

5JH
6JH
6AR
6JH
6JHquot;Harlan Grovequot; wrote:

gt; Gary Reger wrote...
gt; gt;data that i have is
gt; gt;
gt; gt; a b c d
gt; gt; jh address telephone number
gt; gt; ar address telephone number
gt; gt; address telephone number
gt; gt;
gt; gt; ar address telephone number
gt; gt;
gt; gt;column a needs needs number 1,2,3,4,5, etc.
gt; gt;but only if column be is jh or ar
gt; gt;and they need to be consecutive like you use with autofill numbering
gt; gt;but it needs to skip the spaces and yet keep the numbering in order
gt;
gt; If your topmost row is in row 1, so the topmost col A cell would be A1,
gt; then try these formulas.
gt;
gt; A1:
gt; =IF(OR(B1={quot;jhquot;,quot;arquot;}),1,quot;quot;)
gt;
gt; A2:
gt; =IF(OR(B2={quot;jhquot;,quot;arquot;}),1 MAX(A$1:A1),quot;quot;)
gt;
gt; Fill A2 down as far as needed.
gt;
gt;

I am sorry this did work. ignore my other reply please

thank you very much for your help

quot;Harlan Grovequot; wrote:

gt; Gary Reger wrote...
gt; gt;data that i have is
gt; gt;
gt; gt; a b c d
gt; gt; jh address telephone number
gt; gt; ar address telephone number
gt; gt; address telephone number
gt; gt;
gt; gt; ar address telephone number
gt; gt;
gt; gt;column a needs needs number 1,2,3,4,5, etc.
gt; gt;but only if column be is jh or ar
gt; gt;and they need to be consecutive like you use with autofill numbering
gt; gt;but it needs to skip the spaces and yet keep the numbering in order
gt;
gt; If your topmost row is in row 1, so the topmost col A cell would be A1,
gt; then try these formulas.
gt;
gt; A1:
gt; =IF(OR(B1={quot;jhquot;,quot;arquot;}),1,quot;quot;)
gt;
gt; A2:
gt; =IF(OR(B2={quot;jhquot;,quot;arquot;}),1 MAX(A$1:A1),quot;quot;)
gt;
gt; Fill A2 down as far as needed.
gt;
gt;