I need to create gift certificates in excel how do I number each .

G

Gus22

I am setting up gift certifcates in excel and I need to number each one
starting at 100-205. Example: on line one column H, I would have Certificate
100 and line 13 Column, I would have Certificate 101 and so on. I need to do
this to 105 certificates and thought that there might be a Formula for this
function.

Thanks for the help!

Gus
 
K

K.S.Warrier

Hi,
please try this.
In column G,from cell G1 to G1365,put numbers from 1 to 1365.Then, in
H1,write =100
In H2,pu formula as =If(Mod($H$1+G1,13)=0,$H$1+Int(G1/13),"")
Copy this formula down from H2 through H1365.Then
You will get in H1=100,H2=101,H3=103,.....H1365=105.Is this that you want?
Thank you,
K.S.Warrier
 

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

Autonumber field in Excel that behaves the same as Access 0
how do i create a repeating student certificate using excel 2
How do I print Gift Certificates in sequence(00001 - 10000)? 4
Creating Gift Certificates in FP 2
How to create field for series of tickets/gift certificate 4
Calculate the median value before a specified list 0
How do I make Publisher print 3 Gift Certificates on one page? 1
how do i make a list of consecutive numbers in a column? 1

Top