Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Is it possible to do a dynamic reference for a transpose?
I'd like to do the transpose of a 12 cell horizontal reference into vertical, but I need the tranpose function to lookup the line of the 12 cells by finding a value in a vertical list. In other words, the value that drives it all is in a list. The 12 cells are to the right of the found cell. So the vertical block of 12 cells (which would be the transposed values), would have to do the following: find the lookup value grab the 12 horizontal cells that start about 10 cells to the right of the found value transpose those 12 cells into vertical. Thx for any help. -- Boris |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
I WANT TO TRANSPOSE LINKS, AS WE TRANSPOSE VALUES | Excel Worksheet Functions | |||
using LOOKUP instead of IF on dynamic row | Excel Worksheet Functions | |||
Can't create dynamic charts | Charts and Charting in Excel | |||
Dynamic charting problems (events) | Charts and Charting in Excel |