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

G

Guest

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?
 
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula autofill to cells below – formula arguments are cell areas in different columns 1
auto fill series between to non-adjacent cells 1
adjacent to a specific sentence 2
How can I fill a series in Nonadjacent cells eg Text 1, Text 2 6
How can I create a drop down list from non-adjacent cells 4
Series of two non-adjacent cells? 4
How do I fill adjacent cells with incrementing numbers 2
How to put series of number in excel while filters applied? 1

Top