Hi
I have a very large spreadsheet with a number of columns of random figures. To sort these lowest to highest I have been transposing the sections of rows requiring sorting to columns and sorting each column separately. Then transposing them back again. Is there an easier way of doing this please
There is an option to sort left to right -- does that do what you want?
Entia non sunt multiplicanda sine necessitate
thanks shg, i wish. no not that easy. i have about 3000 rows of about 15 columns. columns 3 to 9 have data i need to sort lowest to highest and doing them individually is taking forever. can't find a way to do multiple sorts
Post an example and explain what you need?
here is a very basic idea of what im working on. i need to sort lowest to highest column c(44) to column i (38). i have nearly 4 thous rows to sortany help would be very welcome.
PKL 1/05/2009 44 43 34 4 18 10 38
LTI 2/05/2009 34 43 7 4 39 13 9
FTR 2/05/2009 22 35 33 5 27 34 26
YLM 2/05/2009 30 38 37 29 31 24 34
PKL 4/05/2009 45 6 4 26 16 42 37
TPL 4/05/2009 28 25 21 6 19 32 22
DAI 6/05/2009 45 32 34 31 21 42 10
PKL 7/05/2009 26 42 1 12 34 15 21
Last edited by lesley_51; 07-05-2009 at 03:27 AM. Reason: more explanation
try this macro ammended from one i got here
http://forums.techguy.org/business-a...thin-rows.html (have a look and see the nice friendly thread, NOT lol)
Please Login or Register to view this content.
Last edited by martindwilson; 07-05-2009 at 05:31 AM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Thank you martin will try this although never dabbled in macros before. Will be fun
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks