| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Transpose Maybe?
Hi Dan
Try the non-volatile solution of =INDEX(Sheet2!$B:$B,COLUMN(A1)+19) -- Regards Roger Govier "Dan Oakes" wrote in message ups.com... Actually, just a sec... What if my data starts on "Sheet2!B20"? I tried this and it doesnt work: =INDIRECT("Sheet2!B20" & COLUMN()) Thanks again, -- Dan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help using Transpose | Excel Discussion (Misc queries) | |||
| transpose | Excel Worksheet Functions | |||
| I WANT TO TRANSPOSE LINKS, AS WE TRANSPOSE VALUES | Excel Worksheet Functions | |||
| Please Help with TRANSPOSE | Excel Worksheet Functions | |||
| TRANSPOSE() | Excel Worksheet Functions | |||
Threaded Mode
