excel - Divide the value of non-blank cells (in a column) amongst empty cells and repeat with vba -
I start with a sheet like this:
colB: row1: 15 Row2: (empty) line 3: (empty) line 4: 60 line 5: (empty) row 6: 45 line 7: 88 line 8: (empty) row 9: 10 ... line: 56
< / Pre>I want to run the value of non-empty cells (for example, 15 in line 1) are empty in the number of the following cells, which means that, after the change, column B will look like this:
colb: row1: 5 row2: 5 row3: 5 row4: 30 row5: 30 Nkti 6: 45 Line 7: 44 Row 8: 44 Row9: 10 ... rowN: 56
I have no idea that how to do it. Can anyone help me, PLS?
So divide the number by the number of free space + 1? (15/3) Unless there is no empty space, then divide by 1? (45 = 45)
It will anchor a filled chamber and look at its vertical offset and give it to the last cell in B, then re-anchor if one is not empty;
Range set cell = range ("B1") Maximum = range ("B" and rows. End (xlpe) .ró I = I + 1 if (cell. Offset (i, 0) .value
Comments
Post a Comment