sorting by 2 conditions - highest to lowest

[dgiannoccoli]

My Data

Option Description 1 Frequency % Profit/ Unit

No Flooring Desired 118 0%
Kitchen Countertop 80 82%
Tile Upgrade 68 30%
Vanity Cabinets 67 75%
GE Dryer 51 98%
Level II Bath Tile Package 51 75%
Tile Floor Insert 45 62%
Cultured Marble Vanity Top 43 140%
Kitchen Backsplash 36 63%
Carpet Upgrade 35 100%
Closet Doors:Add Cased Opening 34 102%
Extra Single Cable TV Outlet 34 121%
Security Alarm 33 111%
Bath Floor Tile Installation 32 45%
Living Room Hi Hat Package 31 74%
Gutter Option 29 66%
GE Refrigerator 29 73%
Delete Standard Medicine 29 -100%
Moen Bathroom Faucet(s) 28 68%

I wanted to sort by the highest profit that has the highest frequency.
So data should be

Cultured Marble Vanity Top 43 140%
GE Dryer 51 98%
Kitchen Countertop 80 82%
Vanity Cabinets 67 75%
Level II Bath Tile Package 51 75%

And so on....

Thanks

 

[TheNoocH]

if i'm reading you correctly then...
assuming your data is in columns A B C
then you could do
DATA SORT
Select "My list has header Row"
sort by % Profit/Unit --- Decending
then by Frequency ---Decending

hope that helps