Sort from lowest to highest

S

Steved

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

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
 
L

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

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

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

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
 
R

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
 
S

Steved

Hello from Steved

I thankyou all

Thankyou.

Ron Rosenfeld said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top