consecutively number cells in a column range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

please tell me how to consecutively numbers in a column such as a consecutive
invoice numbers
 
Type a 1, a 2, and a 3 in the first 3 cells. Select and drag down.
Alternatively, if you don't want them to show in A until data is entered in
B, you could do something like this:
Put 1 in A2 under the heading (in A1) Invoice Number.
Then, in A3, put =if(isblank(b2),"",a2+1)

*******************
~Anne Troy

www.OfficeArticles.com
 

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

Finding location (or start cell) of highest consecutive values 3
How to count the maximum number of consecutives? 9
Excel and consecutive number 2
Consecutive numbering 4
Counting consecutive negative value 7
How do i doconsecutive numbering on invoices automatically? 4
Highest total of any three consecutive numbers in a range. 11
Counting consecutive numbers in a list 1

Back
Top