Sort from lowest to highest
 

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.

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.

One way: Copy the data to the range H1:M1. Highlight the range, then click
on DATA ... SORT. Click on the OPTIONS button and select "left to right".
Then click OK and sort ascending.

"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.

And if you're copying down to do likewise for A2:F2, A3:F3, etc

Put this instead in H1, array-entered as before,
then copy across to M1, and fill down as required:

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

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

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.

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

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

Hello from Steved

I thankyou all

Thankyou.

"Ron Rosenfeld" wrote:

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