M
Manuel Murieta
I would like the value of the cells in column A to be equal to the value
of the previous nonblank value in column A +1.
For example:
A
1 1
2 2
3
4
5
6 3
7
8
9
10 4
11
12
13
14
15
....
20
21 5
What formula could I place in the cell to add 1 to the value of the
previous non-blank cell in column A
of the previous nonblank value in column A +1.
For example:
A
1 1
2 2
3
4
5
6 3
7
8
9
10 4
11
12
13
14
15
....
20
21 5
What formula could I place in the cell to add 1 to the value of the
previous non-blank cell in column A