Solved

Creating consecutive numbers to be used as invoice numbers

Posted on 2009-03-31
8
554 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

 
LVL 29

Expert Comment

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

Author Comment

by:gwh2
Comment Utility
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
Comment Utility
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
Comment Utility
Perfect! Thanks a million.
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Sometimes Outlook might have problems sending a message. There may be various causes- corrupted PST, AV scanner etc. The message, instead of going to the Sent Items folder, sits in the Outbox indefinitely. To remove it you can use a free tool cal…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…

762 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

7 Experts available now in Live!

Get 1:1 Help Now