Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sort by two columns ends up with wrong sort in 2nd col | Excel Discussion (Misc queries) | |||
How to sort an Excel spreadsheet by more than 3 columns? | Excel Worksheet Functions | |||
Is there a function to auto-sort 2 columns? | Excel Worksheet Functions | |||
how do I sort several columns in excel | Excel Worksheet Functions | |||
Excel Sort function should not sort the cell formatting! | Excel Worksheet Functions |