Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Mar 2011
    Posts
    5
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Excel 2003 - Two column sorting

    I have a spreadsheet that has Commodities listed in column A and Prices for each commodity in column B. I want to sort column B by price, descending high to low. What function will allow the commodity in column A to sort and stay with it's price in column B?

    Thanks for any help.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    When you sort you can select both columns and they will sort together.

    Steve

  3. The Following User Says Thank You to sdckapr For This Useful Post:

    Bkhuna (2011-03-18)

  4. #3
    New Lounger
    Join Date
    Mar 2011
    Posts
    5
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Excel 2003 - Two Column Sorting

    Thank you, works great!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •