Prev: How can I insert a date which is the first date of the following m
Next: VLOOKUP returns incorrect data
From: Ana via OfficeKB.com on 3 Jun 2010 06:20
Stand in cell A1, enter "=C1"uses the "drag link cell" in the down right
corner of a cell. I will automaticly link
A1 - C1
A2 - C2
A3 - C3 ect

My question is if it is possible to drag horisonal and link vertically???

A1 - C1
A2 - D1
A3 - E1

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/excel-functions/201006/1

From: Pete_UK on 3 Jun 2010 07:02
Put this in B1:

=INDEX(C$1:M$1,ROW(A1))

and copy down. Adjust the range C1:M1 to suit how far you want to copy
it down.

Hope this helps.

Pete

On Jun 3, 11:20 am, "Ana via OfficeKB.com" <u51486(a)uwe> wrote:
> Stand in cell A1, enter "=C1"uses the "drag link cell" in the down right
> corner of a cell. I will automaticly link
> A1 - C1
> A2 - C2
> A3 - C3 ect
>
> My question is if it is possible to drag horisonal and link vertically???
>
> A1 - C1
> A2 - D1
> A3 - E1
>
> --
> Message posted via OfficeKB.comhttp://www.officekb.com/Uwe/Forums.aspx/excel-functions/201006/1

From: steve on 3 Jun 2010 07:00
Hi,

Try in "a1"

=INDIRECT(ADDRESS(1,ROW(A3)))

And Fill/Drag the formula down.

Regards
Steve
"Ana via OfficeKB.com" <u51486(a)uwe> wrote in message
news:a8f8094c7f08b(a)uwe...
> Stand in cell A1, enter "=C1"uses the "drag link cell" in the down right
> corner of a cell. I will automaticly link
> A1 - C1
> A2 - C2
> A3 - C3 ect
>
> My question is if it is possible to drag horisonal and link vertically???
>
> A1 - C1
> A2 - D1
> A3 - E1
>
> --
> Message posted via OfficeKB.com
> http://www.officekb.com/Uwe/Forums.aspx/excel-functions/201006/1
>


From: Ashish Mathur on 3 Jun 2010 07:03
Hi,

In cell A1, you may enter the following formula

=INDIRECT(ADDRESS(1,ROW()+2))

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Ana via OfficeKB.com" <u51486(a)uwe> wrote in message
news:a8f8094c7f08b(a)uwe...
> Stand in cell A1, enter "=C1"uses the "drag link cell" in the down right
> corner of a cell. I will automaticly link
> A1 - C1
> A2 - C2
> A3 - C3 ect
>
> My question is if it is possible to drag horisonal and link vertically???
>
> A1 - C1
> A2 - D1
> A3 - E1
>
> --
> Message posted via OfficeKB.com
> http://www.officekb.com/Uwe/Forums.aspx/excel-functions/201006/1
>
From: Ms-Exl-Learner on 3 Jun 2010 07:11
Try this…

Copy and paste the below formula in A1 cell.
=INDIRECT(ADDRESS(1,COLUMN(B1)+ROW()))

Drag it to the remaining cells of A column.

--------------------
(Ms-Exl-Learner)
--------------------


"Ana via OfficeKB.com" wrote:

> Stand in cell A1, enter "=C1"uses the "drag link cell" in the down right
> corner of a cell. I will automaticly link
> A1 - C1
> A2 - C2
> A3 - C3 ect
>
> My question is if it is possible to drag horisonal and link vertically???
>
> A1 - C1
> A2 - D1
> A3 - E1
>
> --
> Message posted via OfficeKB.com
> http://www.officekb.com/Uwe/Forums.aspx/excel-functions/201006/1
>
> .
>
 |  Next  |  Last
Pages: 1 2
Prev: How can I insert a date which is the first date of the following m
Next: VLOOKUP returns incorrect data