View Single Post
  #2   Report Post  
bj
 
Posts: n/a
Default

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

"Microcell" wrote:

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?