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.


Actually, you'd be better off with:

=SMALL($A1:$F1,COLUMN()-7)

So you can drag it down as well as to the right.


--ron