I have a excel spreadsheet like:
What I would like:
Thus, what I am trying to achieve is for the current cell to take the value of the cell directly below value and repeat, skipping each of the directly below cells.
For example, cell
B2 will take the value 10.62 (i.e. cell
B3); then cell
B3 will be skipped; then, cell
B4 will take value of 13.26 (i.e. cell
B5), and following suite...
I have tried this formula:
Then, selecting that row and the row below, which doesn't have any formulae, and dragging down. But, sadly unless I only drag down one then reselect it doesn't work correctly. It seems to take the first selected cells value and then adds 1.