View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Spencer Christensen
 
Posts: n/a
Default 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