How to number only rows used --
 

I'm trying to automatically number rows that have been used, example if there
is a number in B17 then in A17 is one, if there isn't a number in B18, leave
bank and is a number in B19 then in A19 it would enter 2 --
--
Thanks so much--Paula

How to number only rows used --
 

Try this formula entered in A17:

=IF(B17="","",COUNTA(B$17:B17))

Copy down as needed.

--
Biff
Microsoft Excel MVP


"Paula" wrote in message
...
I'm trying to automatically number rows that have been used, example if
there
is a number in B17 then in A17 is one, if there isn't a number in B18,
leave
bank and is a number in B19 then in A19 it would enter 2 --
--
Thanks so much--Paula

How to number only rows used --
 

Hi,

Put this in A1 and drag down as far as required.

=IF(ISNUMBER(B1),COUNT($B$1:B1),"")

"Paula" wrote:

I'm trying to automatically number rows that have been used, example if there
is a number in B17 then in A17 is one, if there isn't a number in B18, leave
bank and is a number in B19 then in A19 it would enter 2 --
--
Thanks so much--Paula

How to number only rows used --
 

Hi Mike -- Wonderful!! worked perfect--
--
Thanks so much--Paula


"Mike H" wrote:

Hi,

Put this in A1 and drag down as far as required.

=IF(ISNUMBER(B1),COUNT($B$1:B1),"")

"Paula" wrote:

I'm trying to automatically number rows that have been used, example if there
is a number in B17 then in A17 is one, if there isn't a number in B18, leave
bank and is a number in B19 then in A19 it would enter 2 --
--
Thanks so much--Paula

How to number only rows used --
 

Glad I could help

"Paula" wrote:

Hi Mike -- Wonderful!! worked perfect--
--
Thanks so much--Paula


"Mike H" wrote:

Hi,

Put this in A1 and drag down as far as required.

=IF(ISNUMBER(B1),COUNT($B$1:B1),"")

"Paula" wrote:

I'm trying to automatically number rows that have been used, example if there
is a number in B17 then in A17 is one, if there isn't a number in B18, leave
bank and is a number in B19 then in A19 it would enter 2 --
--
Thanks so much--Paula

How to number only rows used --
 

Thanks for the info -- This works also --
--
Thanks so much--Paula


"T. Valko" wrote:

Try this formula entered in A17:

=IF(B17="","",COUNTA(B$17:B17))

Copy down as needed.

--
Biff
Microsoft Excel MVP


"Paula" wrote in message
...
I'm trying to automatically number rows that have been used, example if
there
is a number in B17 then in A17 is one, if there isn't a number in B18,
leave
bank and is a number in B19 then in A19 it would enter 2 --
--
Thanks so much--Paula

How to number only rows used --
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Paula" wrote in message
...
Thanks for the info -- This works also --
--
Thanks so much--Paula


"T. Valko" wrote:

Try this formula entered in A17:

=IF(B17="","",COUNTA(B$17:B17))

Copy down as needed.

--
Biff
Microsoft Excel MVP


"Paula" wrote in message
...
I'm trying to automatically number rows that have been used, example if
there
is a number in B17 then in A17 is one, if there isn't a number in B18,
leave
bank and is a number in B19 then in A19 it would enter 2 --
--
Thanks so much--Paula