Copying data that is not set in a specific pattern

Z

Zita du Toit

I have to put data in a column but to do that I have to
manually type in =B18; =B53; =B88 etc. for aLOT of data
points. The data is wregularly separated by 35 rows. Is
there a shorter way of doing this?
 
S

Stefan Hägglund [MSFT]

Hi!

Copy the formula, hold down CTRL and select all cells where you want to put
the formula, then paste the formula using Ctrl+V or Edit, Paste.


Best regards


Stefan Hägglund
Microsoft
 
F

Frank Kabel

Hi
try the following formula
=OFFSET($B$18,(ROW(1:1)-1)*35,0)
and copy this down
 
Top