Solved

Creating consecutive numbers to be used as invoice numbers

Posted on 2009-03-31
8
567 Views
Last Modified: 2012-05-06
Hi everyone,

I'm using an excel spreadsheet to record customer data that will eventually be populating a pdf form. I need to have a column in excel that will create consecutive invoice numbers for each customer record.

Can someone show me how to do this if it's possible in excel?

Appreciate any help.
0
Comment
Question by:gwh2
  • 3
  • 3
  • 2
8 Comments
 
LVL 29

Expert Comment

by:QPR
ID: 24027401
you could type an initial value in a cell and then go to Edit / Fill / series and click on "step value" and enter 1.
0
 
LVL 1

Author Comment

by:gwh2
ID: 24027429
Thanks for the reply,

I just tried your suggestion. I have 1 initial record and one of the column headings is called invoice_no. I went to the first record (row) and clicked in the cell below the heading called invoice_no and typed in an initial value, ie. GO0001. I then went to Edit > fill > fill series and put in 1 next to "step value" as you suggested. But then when I click in the cell below the one I just created, nothing happens, ie. the next value doesn't come up.

Do you know what I'm doing wrong?
0
 
LVL 50

Expert Comment

by:Dave Brett
ID: 24027460
If you put
="Go"&TEXT(ROW(),"0000")
in A1
and copy down
then yuou will get an incrementing list Go0001, Go0002 etc
Cheers
Dave
0
 
LVL 29

Expert Comment

by:QPR
ID: 24027463
Ahhh so we aren't talking numbers strictly then
you will need to create some sort of formula that will take the numeric portion of your invoice value, add 1 to it then string it back together.... something I couldn't do off the top of my head and would need to Google.
A quick qorkaround may be to span the invoice value over 2 columns with 1 column just having the GO and the next column having the step value
0
Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

 
LVL 29

Expert Comment

by:QPR
ID: 24027467
oops qorkaround = workaround!
But ignore that, Dave has hit the nail on the head.
0
 
LVL 1

Author Comment

by:gwh2
ID: 24027503
Thanks - the formula works great but what if I need to have a heading in A1? If I put the formula in A2 it starts at GO0002. Is there a workaround?
0
 
LVL 50

Accepted Solution

by:
Dave Brett earned 500 total points
ID: 24027534
You could try this variant
="Go"&TEXT(ROW()-ROW($A$2)+1,"0000")
where $A$2 is always the first cell in your list (so A2 gives 1, A3 gives 2 etc)
or just
="Go"&TEXT(ROW()-1,"0000")
to hardcode subtracting 1
 
Cheers
Dave
0
 
LVL 1

Author Closing Comment

by:gwh2
ID: 31564752
Perfect! Thanks a million.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Are you unable to connect or configure Hotmail email account in Microsoft Outlook 2010, 2007? Or Outlook.com emails are not downloading to Outlook? Lets’ see the problem and resolve Outlook Connector error syncing folder hierarchy (0x8004102A).
MS Outlook is a world-class email client application that is mainly used for e-communication globally.  In this article, we will discuss the basic idea about MS Outlook, its advanced features, and types of MS Outlook File formats.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now