Please HELP!!
I am trying to use the auto fill series but I need the series to start over every time the value change in another column.
If i use the auto fill series, it will copy 1,2,3,4,5 and so forth til the end of the column. In this case, i need the auto fill or some other function that will restart once it encounters a different value under the ID column. I've started below to show an example.
ID No
0.1114 1
0.1114 2
0.1114 3
0.112 1
0.112 2
0.112 3
0.112 4
0.112 5
0.112 6
0.1121
0.1121
0.1121
0.1121
0.1121
0.1121
0.1122
0.1122
0.1122
0.1122
0.1122
0.1122
0.1122
0.113
0.113
0.113
0.113
0.113
I am trying to use the auto fill series but I need the series to start over every time the value change in another column.
If i use the auto fill series, it will copy 1,2,3,4,5 and so forth til the end of the column. In this case, i need the auto fill or some other function that will restart once it encounters a different value under the ID column. I've started below to show an example.
ID No
0.1114 1
0.1114 2
0.1114 3
0.112 1
0.112 2
0.112 3
0.112 4
0.112 5
0.112 6
0.1121
0.1121
0.1121
0.1121
0.1121
0.1121
0.1122
0.1122
0.1122
0.1122
0.1122
0.1122
0.1122
0.113
0.113
0.113
0.113
0.113