Put these nvalues/formulas in cells
C2: Initial
C3: =IF(OR($A3-$A2>20,$A3=""),"End",IF($A2-$A1>20,"Initial",""))
copy C3 down
B2: 1
B3: =IF($C2="Initial",1,$B1+1)
copy B3 down
Put these nvalues/formulas in cells
C2: Initial
C3: =IF(OR($A3-$A2>20,$A3=""),"End",IF($A2-$A1>20,"Initial",""))
copy C3 down
B2: 1
B3: =IF($C2="Initial",1,$B1+1)
copy B3 down
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Reply With Quote
