![]() 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |