Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Resetting values based on change in cells of other column
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 | |
|
|
Similar Threads | ||||
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) |