How can I autofill a series to reference non adjacent cells?
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? |
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? |
All times are GMT +1. The time now is 01:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com