On Sat, 10 Sep 2005 03:33:02 -0700, 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.

For a formula solution:

In H1 enter the formula:

=SMALL($A$1:$F$1,COLUMN()-7)

Copy/drag to M1.

============================


--ron