Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
HOW TO RESTART COUNT FORMULA | Excel Discussion (Misc queries) | |||
Won't restart after close | Excel Discussion (Misc queries) | |||
How to de-install a new update to restart excel | Excel Discussion (Misc queries) | |||
Is there way to restart page numbering for each tab in worksheet | Excel Worksheet Functions | |||
Automatic Updates should not be able to restart your computer when | Excel Discussion (Misc queries) |