That’s why we don’t add a $-sign in front of the column (“F”). We want this number to increase when we pull the formula to the right hand side.
This base cell should not change when we copy and paste the formula so that we insert the $-signs.
In our case, the base cell is the left top corner cell of the range we want to transpose and link.The following number match to the picture above: with ROW() or COLUMN()) but this is the fastest and easiest method. There are certainly more elegant ways (e.g. Roughly said, you define a base cell and tell Excel which value counting from the base cell to return.įirst: Prepare the number 0-2 (the maximum number of rows – 1) on the top and 0 to 1 on the left hand side. The OFFSET function is powerful but unfortunately especially for beginners not very easy to use. Workaround: Use the OFFSET formula for pasting links and tranpose them at the same time
0 kommentar(er)
