Forum Discussion
Problem with moving formula to new column
Problem with moving formula to new column, it affects the next formula in the same row. Which makes the second formula incorrect! Current formula: "=(CW786-BS786)/(AANTAL.LEGE.CELLEN(BS786:CW786)+1)...
I can't reproduce the problem.
If I use Shift+Delete and Shift+Insert or Ctrl+X and Ctrl+V to cut and paste, the formula remains exactly the same: the cell references are unchanged. This also holds if I simply drag a cell three columns to the right.
If I use Ctrl+C and Ctrl+V to copy and paste, all cell references are shifted 3 columns to the right.
Hi Hans,
Can't explain it either. I created a new worksheet, copied the raw-data in. Moved the formula,
3 to the right: Oké.
5 to the right, Oké.
3 to the right, Oké.
7 to the LEFT bingo error in the second part of the formula where I try to determine the number of empty cells, to create the correct output.
But normally I would only move the formula to the right.
In this case I wanted to reproduce the error.
Kind regards, Eddy
Can't explain it either. I created a new worksheet, copied the raw-data in. Moved the formula,
3 to the right: Oké.
5 to the right, Oké.
3 to the right, Oké.
7 to the LEFT bingo error in the second part of the formula where I try to determine the number of empty cells, to create the correct output.
But normally I would only move the formula to the right.
In this case I wanted to reproduce the error.
Kind regards, Eddy