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.