CELL REFERENCES

[Geoff]

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?

 

[Don Guillett]

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

 

[Gord Dibben]

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

 

[Geoff]

Gord

Many thanks. This works.

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

Geoff

 

[Gord Dibben]

See also Don's suggestion.

I like it mo' better.


Gord