G
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?
and so on. =A1+6 doesn't work. Is there a way?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Don Guillett
try this idea
=INDIRECT("a"&ROW(A1)*7)
=INDIRECT("a"&ROW(A1)*7)
G
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
In B2 enter this formula =OFFSET($A$1,6*ROW()-6,0)
Coipy down as far as you wish.
Gord Dibben MS Excel MVP
G
Geoff
Gord
Many thanks. This works.
I have nearly 2,000 rows so great time saver.
Geoff
Many thanks. This works.
I have nearly 2,000 rows so great time saver.
Geoff
G
Gord Dibben
See also Don's suggestion.
I like it mo' better.
Gord
I like it mo' better.
Gord