THE DATA
A
1 hello
2 my
3 excel
4 world
DESIRED RESULT in col C using Formula increment
C
6 Hello
7
8 my
9
10 excel
11
12 world
13
What I attempted
C6 =$A1
C8 =$A2
SELECT C6-C9 and drag 2 rows to increment formula
RESULT
C10 =$A5, not the desired C10 =$A3
Any help would be appreciated.
A
1 hello
2 my
3 excel
4 world
DESIRED RESULT in col C using Formula increment
C
6 Hello
7
8 my
9
10 excel
11
12 world
13
What I attempted
C6 =$A1
C8 =$A2
SELECT C6-C9 and drag 2 rows to increment formula
RESULT
C10 =$A5, not the desired C10 =$A3
Any help would be appreciated.