autonumbering a column in excel

  • Thread starter Thread starter Chris Lai
  • Start date Start date
Hi
the following formulas will put a sequencing number in column A, if
column B is filled:

in A1 enter the following formula
=IF(B1<>"",1,"")

in A2 enter the formula
=IF(B2<>"",MAX($A$1:OFFSET($A2,-1,0))+1,"")
and copy this formula down for as many rows as you like
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro for autonumbering 3
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Create table query... want to insert autonumber column 3
Column widths in Excel 2013 16
Help needed 0
Printing SQL query results in a list of columns, instead of one long column 1
Importing data from excel spreadsheet 1
why won't text-to-columns work here? 6

Back
Top