How can I autofill a series to reference non adjacent cells?

M

Microcell

I need to create a list of values by referencing a series of non adjacent
cells (they are separated by a set number of rows each but in the same
column). For example the cells should read something like =b2 =b4 =b6
=b8. Of course I could type these in individually but threre are something
like 100 values. Is there a way to auto fill this?
 
B

bj

Look at the indirect function for your example
=indirect("B"&(row()*2))
copied down a column will give you a list for non adjacencies.
 
Top