Skipping to the next cell in a worksheet

[Lo]

If I have data beginning with cell A1 and want to 'count'
every 14 rows and pick up the data in the next cell (e.g.
A15) in my next line item, how do I put in a formula that
does this (I'm not savvy with VBE, so is there a way to
key this in - short of keying in the cell locations, e.g.
A1, A15, A29, etc.)?

 

[Frank Kabel]

Hi
in B1 enter
=OFFSET($A$1,(ROW()-1)*14,0)
and copy down

 

[Jason Morin]

Put this in B1 and fill down:

=OFFSET($A$1,ROW()*14-14,)

HTH
Jason
Atlanta, GA

 

[JE McGimpsey]

One way:

B1: =INDEX(A:A,(ROW()-1)*14+1)

Copy down as far as desired.