Thread: Auto numbering
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Auto numbering

.. is it possible in column A to run a function which will count
automatically only the rows of column B that have input


In A2: =IF(B2="","",COUNTA(B$2:B2))
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,000 Files:362 Subscribers:62
xdemechanik
---