HOW TO RESTART COUNT FORMULA
 

Try this... pretend the data starts in A1 and you type in 1 in A1

So in A2 put the formula

=IF(A1="RESTART",2,A1+1)

The only problem with this is that when you manually type in RESTART it
erases the formula from that cell. This could or could not be a problem for
you but it does automatically restart the count when you type it in.

"tgcali" wrote:

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?