How to insert rows in transposed data table?
|
How to insert rows in transposed data table?
Sorry, the formula should have been:
=INDEX($A$1:$D$10,COLUMN(A1),ROW(A1)) Hans "Hans Knudsen" skrev i en meddelelse ... Am I right that you have used a matrix formula like: =TRANSPOSE(range)? If so, try instead =INDEX($A$1:$D$10,COLUMN($A$1),ROW($A$1)) if you have your data in A1:D10. Regards Hans "Mike" skrev i en meddelelse ... Hello All, I attempted to add rows in a pre-set transposed data table and was unable. The message shows "you cannot change part of array". For those who have answers, please kindly forward your advise to me, truly appreciate your help! Regards, Mike |
All times are GMT +1. The time now is 08:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com