CELL REFERENCES
 

In a column I want the first cell to be =A1 but then the next cell to be =A7
and so on. =A1+6 doesn't work. Is there a way?

CELL REFERENCES
 

try this idea
=INDIRECT("a"&ROW(A1)*7)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Geoff" wrote in message
...
In a column I want the first cell to be =A1 but then the next cell to be
=A7
and so on. =A1+6 doesn't work. Is there a way?

CELL REFERENCES
 

In B1 enter =A1

In B2 enter this formula =OFFSET($A$1,6*ROW()-6,0)

Coipy down as far as you wish.


Gord Dibben MS Excel MVP

On Tue, 26 Aug 2008 08:06:09 -0700, Geoff
wrote:

In a column I want the first cell to be =A1 but then the next cell to be =A7
and so on. =A1+6 doesn't work. Is there a way?

CELL REFERENCES
 

Gord

Many thanks. This works.

I have nearly 2,000 rows so great time saver.

Geoff



"Gord Dibben" wrote:

In B1 enter =A1

In B2 enter this formula =OFFSET($A$1,6*ROW()-6,0)

Coipy down as far as you wish.


Gord Dibben MS Excel MVP

On Tue, 26 Aug 2008 08:06:09 -0700, Geoff
wrote:

In a column I want the first cell to be =A1 but then the next cell to be =A7
and so on. =A1+6 doesn't work. Is there a way?

CELL REFERENCES
 

See also Don's suggestion.

I like it mo' better.


Gord

On Tue, 26 Aug 2008 09:33:01 -0700, Geoff
wrote:

Gord

Many thanks. This works.

I have nearly 2,000 rows so great time saver.

Geoff



"Gord Dibben" wrote:

In B1 enter =A1

In B2 enter this formula =OFFSET($A$1,6*ROW()-6,0)

Coipy down as far as you wish.


Gord Dibben MS Excel MVP

On Tue, 26 Aug 2008 08:06:09 -0700, Geoff
wrote:

In a column I want the first cell to be =A1 but then the next cell to be =A7
and so on. =A1+6 doesn't work. Is there a way?