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: ...
tonekil83I forgot something, or actually I told you wrong, in Sheet 2 Cell C2 enter 0 then Cell C3 enter 2. Then, Highlight those cells and drag them down to fill the series. It will show as:
C2 = 0
C3 = 2
C4 = 4
C5 = 6