Reference every 4th row

[cmb80]

Hi all in Column B I have my list (From B3 to B1000)

In column J i want to reference every 4th cell (So B3, B7, B11, B15 and so on). In K I want to reference B4, B8, B12, B16, in L I want to reference B5,B9,B13,B17 etc and in M I want to reference B6,B10,B14,B18 and so on.

I can't do this with paste formulas or dragging the cells down - can anyone advise a quick way to do this?

[kev_]

in J2 copy down
=INDIRECT(ADDRESS(((ROW()-1)*4-1),2))


To understand how it works, put this in a cell in row 2 and copy down:
=(ROW()-1)*4-1
If the cell requiring B3 is not J2, amend this element of the formula

After understanding how it works, you shuld be able to adapt to to columns K,L & M

[leelnich]

Hi all- Paste this in J3, drag across to M3 then copy down:

Please Login or Register  to view this content.

[cmb80]

Many thanks

[leelnich]

No problem, happy to help! Thank you for the rep. - Lee