View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default 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?