How do I extract data from every other cell in a colomn?
 

I have a long colomn of data that i pasted from the web. I want to get the
data from every other cell. (i.e. A2, A4, A6, A8, A10 . . . ECT) I want to
write a formula that will will take that sequence and then let me autofil and
continue the sequence. How do I do that? For the life of me I can not
figure it out.
I would be most grateful if you could help me!


Spencer

How do I extract data from every other cell in a colomn?
 

Hi!

Try this:

=INDEX(A:A,ROWS($1:1)*2)

Copy down as needed.

Biff

"Spencer Christensen" <Spencer wrote
in message ...
I have a long colomn of data that i pasted from the web. I want to get the
data from every other cell. (i.e. A2, A4, A6, A8, A10 . . . ECT) I want
to
write a formula that will will take that sequence and then let me autofil
and
continue the sequence. How do I do that? For the life of me I can not
figure it out.
I would be most grateful if you could help me!


Spencer