How to select cells (located in a column) for formulas in a row automatically?

[Dmitry Kopnichev]

Hello
How to use cells (located in a column) in formulas in a row automatically? I
cannot copy the formula to other cells in the row because the coping moves
the selection to another column, not to a another row in the same column.

[Dorian C. Chalom]

Use a $ (dollar sign) infront of the row or column you do not wat to
change.

"Dmitry Kopnichev" <kopn@bk.ruDelete> wrote in message
news:OqbeN%23lzFHA.460@TK2MSFTNGP15.phx.gbl...
> Hello
> How to use cells (located in a column) in formulas in a row automatically?
> I
> cannot copy the formula to other cells in the row because the coping moves
> the selection to another column, not to a another row in the same column.
>
>

[Dmitry Kopnichev]

The $ (dollar sign) will not move the selection in the column accordingly;
will keep the selection the same. I want to use other cells in the column in
other formulas in the row.
"Dorian C. Chalom" <DChalom@Comcast.net> сообщил/сообщила в новостях
следующее: news:uL%23f8CmzFHA.1256@TK2MSFTNGP09.phx.gbl...
> Use a $ (dollar sign) infront of the row or column you do not wat to
> change.
>
> "Dmitry Kopnichev" <kopn@bk.ruDelete> wrote in message
> news:OqbeN%23lzFHA.460@TK2MSFTNGP15.phx.gbl...
> > Hello
> > How to use cells (located in a column) in formulas in a row
automatically?
> > I
> > cannot copy the formula to other cells in the row because the coping
moves
> > the selection to another column, not to a another row in the same
column.
> >
> >
>
>

[Herbert Seidenberg]

Use names.
Assuming your data looks like this:
Data Results
1 1
2
3 1
4 2
5 3
6 4
7 5
8
9 1
10 2
Select all and
Insert > Name > Create > Top Row
The formula for the first cell in Results is
=INDEX(Data,1)
and for the second block in Results
=INDEX(Data,1):INDEX(Data,5)
and an alternate formula for the last block
=OFFSET(Data,0,0,2)
The last two are array formulas entered with
Shift+Ctrl+Enter.
You can copy the Results to any row or column
without changes.