If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
transpose array of non-adjacent cells
I have a range of cells in a single row. This range is C3:AD3. I am trying to
transpose this specific cells from that range into a single column, B34:B43. In effect, it would look like this: =TRANSPOSE({$C$3,$F$3,$I$3,$L$3,$O$3,$R$3,$U$3,$X$ 3,$AA$3,$AD$3}) Furthermore, I want to sort this list, so it would look like this: =SORT(TRANSPOSE({$C$3,$F$3,$I$3,$L$3,$O$3,$R$3,$U$ 3,$X$3,$AA$3,$AD$3})) Neither of these functions work, and it seems the culprit is that Excel 2007 doesn't want to support non-adjacent cells in an array. How can I get around this without the use of some ridiculous macro? I just want it to try a group of non-adjacent cells as a single array. |
Thread Tools | |
Display Modes | |
|
|