Subscribe
Hi, I need help on filling a formula down with a constant increment. I would like the first cell to be '=+B1' the next to be '=+B4' the next to be '=+B7' etc... so that the increment is 3. How can this be accomplished?
fill down a formula with an increment
(6 posts) (4 voices)-
dhammer
MemberI'm sure there's a more elegant solution, and this requires a dummy column, but using offset would work. In cell C1 (or whatever column you're using) enter the formula OFFSET($B$1,D1,0) and copy down. In column D1:D! copy down increments of 3 (so D1=0, D2=3, D3=6 etc.)
Posted 7 months ago # -
You can also use ROWS() formula.
in Column C, write: =+offset($b$1,rows($C$1:C1)*3,0)) and copy down
Posted 7 months ago # -
leobrollo
MemberHi.
My name is Leo and i'm from Nova Friburgo, Brasil.
This is my first post here.
So, I want to understand that formula presented by Chandoo. I didn't realize what it gives as a result. I wrote the formula exactly as explained above, but I didn't understand its result. When I copy it down, it gives only 0 (zero) in all cells.Regars,
LeoPosted 7 months ago # -
leo... it will give only zeros if Column B is empty.
Posted 7 months ago #
Reply
You must log in to post.
