Hello All,
I had written a post titled How to move value in cells to every fifth cell down.
I got a lot of help but when i went back to reply it stated something went wrong and can now not reply.
So i will reply here sorry,
In reply to
JohnSUNЛідер
It looks like you missed this part:
Not E2:F2 but E2:F5
Please try this
I had been doing that wrong e2:f2 instead of e2:f5 it works now in example, but when i try in my
proper spreadsheet I cannot make it work.
I changed the formula
=INDEX($A$1:$B$10000;(ROW(E2)+6)/4;1)
to
=INDEX($January.$A$4:$January.$A$33,(ROW(A3)+6/4,1)).Its basically the same with more values
I do not understand what the values of+6/4,1 are for . Also office keeps changing my semicolons into commas.