| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I link data from a horizontal range to a vertical range?
How do I link data from a horizontal to a vertical range when the ranges are
in different worksheets of the same workbook. I have used the =INDEX(xx:xx, columns($A:A), rows(1:1))) formula when two different workbooks are involved -- and it works great. But, it doesn't work for the same workbook -- what am I doing wrong? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need to paste link from 4 vertical cells to 4 horizontal cells? | Excel Discussion (Misc queries) | |||
| transposing vertical data to horizontal with varying amount of data | Excel Discussion (Misc queries) | |||
| Minimize range on vertical axis with large data gaps | Charts and Charting in Excel | |||
| How to make Horizontal data go Vertical | Excel Worksheet Functions | |||
| tranfere vertical data to horizontal tabel | Excel Worksheet Functions | |||
Threaded Mode
