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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> 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 <[email protected]>
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 <[email protected]>
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 <[email protected]>
> 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
>