Sort from lowest to highest

[Guest]

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.

 

[Max]

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

 

[Lewis Clark]

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.

 

[Max]

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))

 

[Aladin Akyurek]

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)),"")

 

[Ron Rosenfeld]

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

 

[Ron Rosenfeld]

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

 

[Guest]

Hello from Steved

I thankyou all

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