HOW TO RESTART COUNT FORMULA

T

tgcali

Hello,

I need to have 24 rows that count from 1 on down in column A.
1
2
3, etc.

If on any given row RESTART is entered, I need the count to start over on
the next row from two to the end of the list. In other words RESTART would be
substituted for the number 1 and the count would continue:

RESTART
2
3, etc.

Can I do this?
 
F

Fred Smith

Where is RESTART entered? Assuming it's column A, try something like:

=if(a2="RESTART",2,a2+1)

And copy it down.

Regards,
Fred.
 
Top