Thanks:  0
Likes:  0

# Thread: this must be easy

1. ....A
1 joe
2 dan
3 mark
4 jack
5 bob
lets say we have a column with these names
and we want to copy a1 to f1 and a3 to f2 and
a5 to f3 so f column will look like

...F
1 joe
2 mark
3 bob
is there a way for this

2. What exactly are you trying to do? Take every other name from column A and put them in consecutive rows in column F?

I'm assuming that column A is larger than just 5 rows of data or else you would just do this manually with the formula in F1 being "=A1" (or whatever cell you want).

3. HELLO
of course column A is around 9000 rows and i want a formula to copy (for example) cell a1 then cell a3 then cell a5 and so on... to column F but
to f1,f2,f3,f4 and so on

4. İ JUST WANT TO KNOW İF THİS İS POSSİBLE
A FORMULA MAYBE?

5. Yeah, it's possible.

Assuming your data is in A1 and you want the other list to start in F1, put this formula in cell F1:

=OFFSET(\$A\$1,((ROW(F1)*2)-2),0)

Copy this formula as far down as you need.

6. or, in F1 :

=INDIRECT("A"&(ROW()*2)-1)

Copy this formula as far down as you need.

_________________
Hope this helps,
Chris

[ This Message was edited by: Chris Davison on 2002-04-18 13:33 ]

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•