View Single Post
  #2   Report Post  
K.S.Warrier
 
Posts: n/a
Default

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

"Gus22" wrote:

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