Cell Offset

J

Jon C

Hi,

I’d like to be able to do an offset from a reference in another cell… Help…..

Here’s what I really mean.

A1 contains ‘January’
B1 ‘February’
Etc


A8 = A1, B8 = B1, etc.

Dead easy.

What I’d like to do is change A8 to say C1, for March, and for the remainder
of the cells on row 8 to automatically follow in line i.e. B8=D1, etc.

Thanks,

Jon
 
M

Max

One play ..

Assume you have in A1:L1 : Jan, Feb, Mar, etc

Let's reserve say, cell A7 for the input of the starting cell
Enter in A7: A1

Now put in A8:
=OFFSET(INDIRECT($A$7),,COLUMNS($A$1:A1)-1)

Copy A8 across to L8
A8:L8 will returns what's in A1:L1

Change the input in A7 to: C1
A8:L8 will now return what's in C1:N1,
viz: Mar, Apr, May, ... etc
(i.e. shifts the "starting" cell to C1 instead)
 
K

Krishnakumar

Hi Jon,

Try in A8 and copied across,

=IF(ISERROR(INDEX($A$1:$L$1,$A$9+COLUMN(A1)-1)),"",INDEX($A$1:$L$1,$A$9+COLUMN(A1)-1))

where A9 houses the starting month. if you type 3 then it starts fro
March onwards.

HT
 
Top