HOW TO RESTART COUNT FORMULA
Where is RESTART entered? Assuming it's column A, try something like:
=if(a2="RESTART",2,a2+1)
And copy it down.
Regards,
Fred.
"tgcali" wrote in message
...
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?
|