J
jp
Say I have the following sheet
A
1 c
2 a
3 b
4 c
5 d
6 a
7 c
8 a
9 b
10 c
How can I create a column in B that displays the values in A1, A3, A5,
A7, A9. Excel will not allow me to just put "=A1" in B1 and "=A3" in
B2 and then drag that pattern down. It does not recognize that
pattern. Help! The answer sheet needs to look like this:
A B
1 c c
2 a b
3 b d
4 c c
5 d b
6 a
7 c
8 a
9 b
10 c
A
1 c
2 a
3 b
4 c
5 d
6 a
7 c
8 a
9 b
10 c
How can I create a column in B that displays the values in A1, A3, A5,
A7, A9. Excel will not allow me to just put "=A1" in B1 and "=A3" in
B2 and then drag that pattern down. It does not recognize that
pattern. Help! The answer sheet needs to look like this:
A B
1 c c
2 a b
3 b d
4 c c
5 d b
6 a
7 c
8 a
9 b
10 c