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
Bookmarks