Hi

I have posted this erroneously in excel programming. Sorry for posting
in 2 separte groups.

I am using the illustration below to explain my problem.


1 2 3 4 5 and so on

1 "Val1"
2 "Val2"
3 "Val3"
4
5


In another cell, I have a value "say" 6. In the first row, I want
"Val1" to be copied from Column 2 to Column 6 (6 entries). By the same
logic, in ROW 2, "Val2" will be copied from Column 3 to Column 7.

Is there a way of doing this using formulae or function?


Best Regards
Prasad

If your data is all in Column A, try this in Cell B1:
=INDIRECT("a"&COLUMN()+-1)

Alternatively, try this in Cell B1:
=OFFSET($A$1,COLUMN(A1)+ROW(A1)-2,)


Hope it helps.
Ryan--

--
RyGuy


" wrote:

Hi

I have posted this erroneously in excel programming. Sorry for posting
in 2 separte groups.

I am using the illustration below to explain my problem.


1 2 3 4 5 and so on

1 "Val1"
2 "Val2"
3 "Val3"
4
5


In another cell, I have a value "say" 6. In the first row, I want
"Val1" to be copied from Column 2 to Column 6 (6 entries). By the same
logic, in ROW 2, "Val2" will be copied from Column 3 to Column 7.

Is there a way of doing this using formulae or function?


Best Regards
Prasad

On Nov 5, 10:07 pm, ryguy7272
wrote:
If your data is all in Column A, try this in Cell B1:
=INDIRECT("a"&COLUMN()+-1)

Alternatively, try this in Cell B1:
=OFFSET($A$1,COLUMN(A1)+ROW(A1)-2,)

Hope it helps.
Ryan--

--
RyGuy



" wrote:
Hi

I have posted this erroneously in excel programming. Sorry for posting
in 2 separte groups.

I am using the illustration below to explain my problem.

1 2 3 4 5 and so on

1 "Val1"
2 "Val2"
3 "Val3"
4
5

In another cell, I have a value "say" 6. In the first row, I want
"Val1" to be copied from Column 2 to Column 6 (6 entries). By the same
logic, in ROW 2, "Val2" will be copied from Column 3 to Column 7.

Is there a way of doing this using formulae or function?

Best Regards
Prasad- Hide quoted text -

- Show quoted text -

Thanks for your inout Ryan.

If it helped, please click the "Yes" button.
Thanks,
Ryan--
--
RyGuy


" wrote:

On Nov 5, 10:07 pm, ryguy7272
wrote:
If your data is all in Column A, try this in Cell B1:
=INDIRECT("a"&COLUMN()+-1)

Alternatively, try this in Cell B1:
=OFFSET($A$1,COLUMN(A1)+ROW(A1)-2,)

Hope it helps.
Ryan--

--
RyGuy



" wrote:
Hi

I have posted this erroneously in excel programming. Sorry for posting
in 2 separte groups.

I am using the illustration below to explain my problem.

1 2 3 4 5 and so on

1 "Val1"
2 "Val2"
3 "Val3"
4
5

In another cell, I have a value "say" 6. In the first row, I want
"Val1" to be copied from Column 2 to Column 6 (6 entries). By the same
logic, in ROW 2, "Val2" will be copied from Column 3 to Column 7.

Is there a way of doing this using formulae or function?

Best Regards
Prasad- Hide quoted text -

- Show quoted text -

Thanks for your inout Ryan.