Sorting data

[Sonja]

I have a spreadsheet consisting of 500 rows by 8 columns.
Each of the 8 cells in the row has a number which I need
to sort into order starting with the lowest number

eg. 12 6 31 45 2 20 to 2 6 12 20 31 45

I can do it for individual rows but as I need to apply it
to 500 is there a way to do it?

Thanks

 

[Bob Phillips]

Sonja,

Not exactly sorting, but create a sorted list.

Assuming your data is in A1:F500
Put this formula in G1
=SMALL($A1:$F1,COLUMN(A1))
Copy G1 across to L1
Copy G1:L1 down to G500:L500

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Peo Sjoblom]

You can do this quite easily using a help sheet, if for instance your
numbers start in A2:H501
in Sheet1, use a help sheet and in A2 in that sheet put this formula

=SMALL(Sheet1!$A2:$H2,COLUMN(A:A))

copy across to H2, now while still selected drag the lower corner of H2
downwards until you get
to H501 or something to copy down the formula or while A2:H2 are still
selected type
A2:H501 in the name box, press enter and the press ctrl + D to copy down the
formula.
While still selected copy the whole range, and do edit>paste special as
values in place.
Now you can replace the old values with the newly sorted values

So if you values start in B5 going to I505 use

=SMALL(Sheet1!$B5:$I5,COLUMN(A:A))

and copy across 8 columns..

 

[Bob Phillips]

Sonja,

Although your example was only 6 numbers, you did say 8 numbers, so you will
need to adapt my suggestion for 8 columns.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)