After using and teaching Excel for years, I have finally run into something I can't figure out.
I have a list of numbers, 10 columns by about 1000 rows.
Each row is a set of data between 1 and 100.
I want each row of numbers sorted from low to high without any reference to adjacent rows.
Is there any way to do this without having to do 1000 individual sorts??
Good afternoon macevanscb
I don't know of a way to do this without resorting to VBA, but it shouldn't be too difficult with a macro.
This code is just a rough trial - it doesn't detect your range or anything. If you have 1,000 rows, change the 20 in line 2. If your data takes up 20 columns change the 10 in line 3 to 20.
Please Login or Register to view this content.
HTH
DominicB
Last edited by dominicb; 05-07-2007 at 08:54 AM.
Please familiarise yourself with the rules before posting. You can find them here.
I don't beleive it can be done except by sorting each row one at a time.
I would suggest a macro to do your sorting
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assistedor failed to assist you
I welcome your Feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks