One way ..

Put in H1, and array-enter the formula
(i.e. press CTRL+SHIFT+ENTER):

=INDEX($A$1:$F$1,MATCH(SMALL(RANK($A$1:$F$1,$A$1:$ F$1,1),COLUMN(A1)),RANK($A
$1:$F$1,$A$1:$F$1,1),0))

Copy H1 across to M1
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Steved" wrote in message
...
Hello from Steved

in Cells A1 to F1 I have

25, 2, 3, 12, 23, 1

ok in cells H1 to M1 Iwould like to have

1, 2, 3, 12, 23, 25 ie lowest to the highest

What formula would I use in H1 to M1 to acheive this please.

Thankyou.