• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Sorting columns of numbers

G

guitarman

Member
Hi There

I wonder if someone could help me out here I want to sort 5 columns of numbers from smallest to largest and there are 250 rows and I want to do them all at once instead of the labourous task of doing them one at a time. I have tried to do it one at a time but when I try the next row the one I have just done reverts back to its original state.

A..B..C..D..E..

17.8.12..21.4

3..11.6..14.19

and I want them like this

A..B..C..D..E

4..8..12.17.21

3..6..11.14.19

But I want to do this is one go

Mike
 
your going to have to use formulas if you need more than 3 rows sorted.


Try this.

Make sure to lock the range

=small(range,row(a1))
 
Hi Montrey

Thanks for a quick response. Unfortunately this does not appear to work all I get is (Name) and I dont really understand what you mean by lock the range does that mean highlight all the rows. Because I am assuming the format is entered into a different cell the cells with the numbers in are A,B,C,D,E. 5 Columns making 250 Rows and I want all 250 Rows sorted from left to right smallest to largest.So I would enter the Formula into G1 is that correct? many thanks

Mike
 
Hi, guitarman!


What Montrey tried to mean is this:

a) assuming your data is in A:E columns with row 1 as title and data from row 2 in advance

b) in G2 type:

=K.ESIMO.MENOR($A2:$E2;COLUMNA(A2)) -----> in english: =SMALL($A2:$E2,COLUMN(A2))

c) copy across thru K2 and down as needed.


Regards!
 
Hi SirJB7

Once again you come to the rescue that worked fine all 250rows sorted in seconds saved me a lot of time. Once again many thanks for sharing your knowledge with me Have a great day and a brilliant life.

Mike
 
As SIRJB7 said, use =small(range,column()) instead. Didn't realize you wanted it across.

SIRJB7's formula should work for your exact situation.
 
Hi, guitarman!

Glad you solved it. Thanks for your feedback and for your kind words too, my reciprocal wishes for you too. Welcome back whenever needed or wanted.

Regards!
 
You must log in or register to reply here.
Back
Top