software

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

Hi!

Try this:

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

Copy down as needed.

Biff

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