Excel Linking Formula

[ebisabes]

if I want column B to read every 7th cell in column A is there a formula I can drag & fill like =(A1)+7Cells??????

does that make sense? in other words:

B1=A1
B2=A8
B3=A15
B4=A22

how can I do this other than individually linking each cell?

 

[pbrodsky]

Look at the help file for the OFFSET function

 

[ebisabes]

ok so if =OFFSET(A1,7,0,1,1) works...

if the formula in A1 reads ='Daily!AG7' & I want my offset formula to read that out of A1... can I do it without manually doing =OFFSET(Daily!AG7,7,0,1,1)

????

 

[pbrodsky]

in b1
=OFFSET($A$1,(ROW(B1)-1)*7,0)

and copy down

 

[SkipVought]

Hi,
[tt]
B1: =INDIRECT("A"&(ROW()-1)*7+1)
[/tt]



Skip,

_[red][/red]