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

Sort excel columns as a function
 

You will need to calculate 1 coefficient per row, that is monotonically
increasing (or decreasing).

Then, in a second range where your output comes, you retrieve (with the
LARGE or SMALL function) the numbers in the correct sequence. Using VLOOKUP
formula's you carry over the other cells of your first table.


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Christian" wrote:

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

Sort excel columns as a function
 

I don't understand the logic behind the example results.

Could you please explain.


Gord Dibben MS Excel MVP

On Sun, 20 Jul 2008 01:22:00 -0700, Christian
wrote:

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