Forum Discussion
Autofill a formula series
Hi. I'm trying to use a formula to take values from every 3rd cell of a column in sheet1 and display them in a column in sheet2 but one after another. So, column A of sheet 2 I want the following: ...
tonekil83Hey there, I think I can help you. Use the Offset Formula. In Sheet1 Cell C2 (or blank adjacent Cell) input a 0 then drag it all the way down to the end of your data, set to fill Series so the numbers truncate. (from 0-100 or whatever the end number might be). Sheet2 do the same thing. In Sheet2 Cell B enter this formula (Example will use cell B2 in Sheet2 to bring the data into this sheet). Adjust formula as needed. =IF(OFFSET(Sheet1!$B$2,Sheet2!C2,0)=0,"",OFFSET(Sheet1!$B$2,Sheet2!C2,0))