Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
I need help with doing the following logic in my worksheet
A B C 1 1 1 1 2 2 1 3 3 2 4 1 2 5 2 I want column C to restart its incrementing whenever column switches to a new value. Any help would be appreciated. |
#2
![]() |
|||
|
|||
![]()
From you example, you want column C to increment unless Column A changes
manually put 1 in C1 first Put =IF(A2=A1,C1+1,1) in cell C2 and copy down. -- Gary's Student "NSteinner" wrote: I need help with doing the following logic in my worksheet A B C 1 1 1 1 2 2 1 3 3 2 4 1 2 5 2 I want column C to restart its incrementing whenever column switches to a new value. Any help would be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can I change a cell and cause an automatic change in other cells | Excel Worksheet Functions | |||
Simultaneously change values in multiple cells? | Excel Worksheet Functions | |||
is it possible to select and change the values of cells in a minimized excel spread sheet from vba? | Excel Worksheet Functions | |||
Adding colour to a range of cells based on one of the cells v... | Excel Discussion (Misc queries) | |||
I Need to change reference sheet for all cells on a form | Excel Discussion (Misc queries) |