Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
transposing question...
There's an article he
http://office.microsoft.com/en-gb/as...260381033.aspx It explains exactly what I'm trying to do almost, I want to transpose this array (from the article close to the bottom): =IF(ISERROR(INDEX($A$1:$B$7,SMALL(IF($A$1:$A$7=$A$ 10,ROW($A$1:$A$7)), ROW(1:1)),2)),"",INDEX($A$1:$B$7,SMALL(IF($A$1:$A$ 7=$A$10,ROW($A$1:$A$7)), ROW(1:1)),2)) I want it to list the numbers not vertically but horizontally. Is there any way I could make the array display it that way by entering something into this formula? I will award an imperial silver medal to anyone who can answer this. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is this the proper place to ask my question? | Excel Discussion (Misc queries) | |||
Pivot table question | Excel Discussion (Misc queries) | |||
Benefits many people - Question | Excel Discussion (Misc queries) | |||
How do I find and replace a question mark in Excel? | Excel Discussion (Misc queries) | |||
An easy macro question and one I believe to be a little more diffi | Excel Worksheet Functions |