Please Help Me.

[kumawat_s]

I have some data horizontly and (a5, b5, c5, d5...........) and want t
link these data vertically i.e. a7, a8, a9, a10......... How I can do

I am attaching my demo file for your reference.

I am using excel 2000.

Please help.

Thanks in advance.

S. Kara

Attachment filename: demo.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=64740

 

[Frank Kabel]

Hi
enter the following in A7:
=OFFSET($A$5,0,ROW(1:1)-1)
and copy down

 

[kumawat_s]

Thank you frank you really solved my problem.

Please also advice for the following

1. If I want to link these data by odd colums (like a, c, e, g, i) then
what function should i apply. As per your function as mentioned below it
works for continuous linking (like a,b,c,d,e...).

2. If I want to link data from vertical to horizontal (reverse
situation from earlier) what should I do.

Thanks again.

S. Karan

 

[Frank Kabel]

Hi
1.
=OFFSET($A$5,0,(ROW(1:1)-1)*2)

2. e.g. your data is in A1:A5 and you want to put it in B1:F1 enter the
following in B1
=OFFSET($A$1,COLUMN(A:A)-1,0)

 

[kumawat_s]

THANKS THANKS THANKS

*Hi
1.
=OFFSET($A$5,0,(ROW(1:1)-1)*2)

2. e.g. your data is in A1:A5 and you want to put it in B1:F1 ente
the
following in B1
=OFFSET($A$1,COLUMN(A:A)-1,0)