this must be easy

Mert · Apr 18th, 2002, 10:45 AM

....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

Mark O'Brien · Apr 18th, 2002, 10:51 AM

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).

Mert · Apr 18th, 2002, 10:56 AM

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

Mert · Apr 18th, 2002, 11:01 AM

Ý JUST WANT TO KNOW ÝF THÝS ÝS POSSÝBLE
A FORMULA MAYBE?

Mark O'Brien · Apr 18th, 2002, 11:12 AM

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.

Chris Davison · Apr 18th, 2002, 02:32 PM

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 ]

Apr 18th, 2002, 10:51 AM	#2
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	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). __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 18th, 2002, 10:45 AM	#1
Mert New Member Join Date: Apr 2002 Posts: 20	....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

Apr 18th, 2002, 10:56 AM	#3
Mert New Member Join Date: Apr 2002 Posts: 20	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

Apr 18th, 2002, 11:01 AM	#4
Mert New Member Join Date: Apr 2002 Posts: 20	Ý JUST WANT TO KNOW ÝF THÝS ÝS POSSÝBLE A FORMULA MAYBE?

Apr 18th, 2002, 11:12 AM	#5
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	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.

Apr 18th, 2002, 02:32 PM	#6
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	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 ]