Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to insert rows in transposed data table?
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to insert rows in transposed data table?
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table - Deleting data rows while maintaining them in the tot | Excel Worksheet Functions | |||
In a pivot table, can the avg of a column include rows w/o data? | Excel Discussion (Misc queries) | |||
consolidation of tables in excel with text and figures | Excel Worksheet Functions | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Data Table - does it work with DDE links and Stock Tickers? | Excel Worksheet Functions |