How to number only rows used --

[Paula]

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 --

 

[T. Valko]

Try this formula entered in A17:

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

Copy down as needed.

 

[Mike H]

Hi,

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

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

 

[Paula]

Hi Mike -- Wonderful!! worked perfect--

 

[Mike H]

Glad I could help

Hi Mike -- Wonderful!! worked perfect--

 

[Paula]

Thanks for the info -- This works also --

 

[T. Valko]

You're welcome. Thanks for the feedback!