Formula Drag Across Link Down
 

Hi Guys

I want to drag my formula across a row but the items i want them to link to
are displayed horizontally?

ie.. i want to drag the formula across and sequentially increase like this.

=a1,=a2,=a3,=a4,=a5,=a6 and so on across, without having to write it obv!

Can this be done?

Formula Drag Across Link Down
 

Hi,

Put this in a cell and drag right and you will get a1, a2 etc

=INDIRECT(ADDRESS(COLUMN(A1 ),1))

Mike

"Bazy2k" wrote:

Hi Guys

I want to drag my formula across a row but the items i want them to link to
are displayed horizontally?

ie.. i want to drag the formula across and sequentially increase like this.

=a1,=a2,=a3,=a4,=a5,=a6 and so on across, without having to write it obv!

Can this be done?

Formula Drag Across Link Down
 

I'd put
$=a1
in the first cell
drag across as far as I needed
Then select those cells
edit|Replace
what: $
with: (leave blank)
replace all



Bazy2k wrote:

Hi Guys

I want to drag my formula across a row but the items i want them to link to
are displayed horizontally?

ie.. i want to drag the formula across and sequentially increase like this.

=a1,=a2,=a3,=a4,=a5,=a6 and so on across, without having to write it obv!

Can this be done?

--

Dave Peterson