LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.misc
Bill Martin
 
Posts: n/a
Default Sorting more than 3 columns of Numeric data.

JMax wrote:
I have a spreadsheet with six (6) columns of numeric data and would like
to sort if ascending in each row. So the end result would be the lowest
numbers in each row at the top of the spreadsheet. Is this possible?

Thanks!


--------------------

Yes it's possible. Let me describe the simple approach first, then from it you
can figure out the more complex and wonderful version on your own.

Sort the entire data set first *only* on the least significant column. Then
sort it a second time *only* on the next least. And so forth until you've
sorted it for the sixth time on *only* the most significant column. If I
understand your request properly, it will end up correctly sorted.

Bill
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Charting Data over 256 Columns Tommy Z. Charts and Charting in Excel 1 December 2nd 05 05:26 AM
Data in table, may need to convert to columns with OFFSET? Ron H Excel Discussion (Misc queries) 5 July 31st 05 06:44 PM
Macro to Synchronize data frm svrl workbooks & columns to 1 workbo jbsand1001 Excel Discussion (Misc queries) 1 April 28th 05 10:42 AM
sort column data with hidden columns - excel 2003 nanimadrina Excel Discussion (Misc queries) 2 April 26th 05 08:27 PM
How do i copy columns of data in notepad into microsoft excel? Jason Excel Discussion (Misc queries) 3 February 12th 05 02:04 AM


All times are GMT +1. The time now is 08:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"