Transpose and order array numbers

I have in B1:C1 three number non-ordered
Like this:
B1:101
C1:103
D1.102

I want
In only one function transpose and order them to A2:A4
Like this:
A2:101
A3:102
A4:103

Can anybody help me?
Best regards
Cradino

Is this a real live problem or a simplified version? Try something like:

=SMALL($B$1:$D$1,ROW(B2)-ROW(B$2)+1)

in cell A2 and then copy down.

--

Vasant



"cradino" <arcindo@debates.microsoft.com> wrote in message
news:217AAB23-DCEA-4917-B5CD-11F58695112A@microsoft.com...
>I have in B1:C1 three number non-ordered
> Like this:
> B1:101
> C1:103
> D1.102
>
> I want
> In only one function transpose and order them to A2:A4
> Like this:
> A2:101
> A3:102
> A4:103
>
> Can anybody help me?
> Best regards
> Cradino

Try this:

=SMALL($1:$1,ROW(1:1))

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

"cradino" <arcindo@debates.microsoft.com> wrote in message
news:217AAB23-DCEA-4917-B5CD-11F58695112A@microsoft.com...
I have in B1:C1 three number non-ordered
Like this:
B1:101
C1:103
D1.102

I want
In only one function transpose and order them to A2:A4
Like this:
A2:101
A3:102
A4:103

Can anybody help me?
Best regards
Cradino