• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Restart Numbering on a reaching a certain value

I

im2fast4u

New Member
Hello,

I am trying to figure out a formula which, based on value, will restart numbering. I am using this formula, but it does not work after the first run, because it is always referencing the same cell with the OFFSET formula:


=IF(($A$22-(D21*$A$21))>0,1,IF($A$23-((OFFSET(D21,0,(COLUMN($D$21)-COLUMN(D$21)))*$A$21))>0,2,""))


The values in the celss are as follows:


A21=1

A22=10

A23=7


D21:T21 = 1,2,3,4,5,6,7,8,9,10,11,12,.....


Can you please suggest a formula where I can restart the numbering when it hits zero


Thank you
 
Wasnt 100% clear of what you wanted, so this may or may not help. Just used the MOD function


https://www.dropbox.com/s/kg31m1xa2o6j7t2/Reset%20Numbering.xlsx
 
You must log in or register to reply here.
Back
Top