LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 24
Default Sort excel columns as a function

Hi, I have the following 3 columns that I want to sort on Risk and then on
Sales.
Risk Name Sales
Mid Joe Farms 24.000
High Sweet Pigs 54.000
Low Calamity Swine 65.300
Low Roasted Pork 76.000
High Bess 120.000
Low Josh Pork 234.000
Mid Carol Sow Farm 136.000

It needs to be automated as the spreadsheet will be handled by
non-proficient excel users (ie no macro or manual sorting).

The output should look like :
Risk Name Sales
Low Josh Pork 234000
Low Roasted Pork 76000
Mid Carol Sow Farm 136000
Mid Joe Farms 24000
Low Calamity Swine 65300
High Bess 120000
High Sweet Pigs 54000

Thanks, Christian



 
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
sort by two columns ends up with wrong sort in 2nd col urbnjckct Excel Discussion (Misc queries) 3 November 2nd 07 01:25 AM
How to sort an Excel spreadsheet by more than 3 columns? William,Summit,Oh Excel Worksheet Functions 2 December 28th 05 04:31 PM
Is there a function to auto-sort 2 columns? mpenkala Excel Worksheet Functions 0 November 9th 05 01:09 AM
how do I sort several columns in excel race510 Excel Worksheet Functions 1 August 6th 05 12:39 AM
Excel Sort function should not sort the cell formatting! Lisa D.N.1 Excel Worksheet Functions 1 December 28th 04 08:37 PM


All times are GMT +1. The time now is 11:28 PM.

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"