Q: rewite this formula for row
Hello,
Based on this site: http://support.microsoft.com/?kbid=214024 The following formula converts rows to columns in the same sheet. =OFFSET($A$1,(ROW()-1)*4+INT((COLUMN()-3)),MOD(COLUMN()-3,1)) How can I convert columns to rows and between sheets, such as take all the columns for row=2 in sheet1 and link it to column B in Sheet2 (not through paste special, the link should be created between sheet1 and sheet2) Any help will be greatly appointed. |
All times are GMT +1. The time now is 06:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com