W
wilchong via OfficeKB.com
There is 1 data set is assumed running in A1 down, viz.:
In A1 down is: 1, 2, 3, 4, 5, 6, 7, 8, 9 and 10
In the cell from B1 to B10 is empty (no value).
My question is that I want a excel formule would performance a task which it
can put a value e.g.1 every "5" cells. So, in my example, after setting the
formula, "1" will incorporate in the cell B5 and B10. Do you think an Excel
function can achieve the result according my requirement?
Many thanks, Wilchong
In A1 down is: 1, 2, 3, 4, 5, 6, 7, 8, 9 and 10
In the cell from B1 to B10 is empty (no value).
My question is that I want a excel formule would performance a task which it
can put a value e.g.1 every "5" cells. So, in my example, after setting the
formula, "1" will incorporate in the cell B5 and B10. Do you think an Excel
function can achieve the result according my requirement?
Many thanks, Wilchong