View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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