In H1 enter and copy across:

=IF(COLUMNS($H$1:H1)<=COUNT($A$1:$F$1),SMALL($A$1: $F$1,COLUMNS($H$1:H1)),"")

Steved wrote:
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.