Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    Seymour, Connecticut, USA
    Posts
    33
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Multiple sort in Excel

    I use Excel in Office 97 and have created a database with it. It contains dates, names, and amounts of money. I can sort or filter the data to a point. However, I want to sort the information by name, have a break at each individual month for each name, and sum the amounts of money for each name for each month. Is this possible with Excel formulas or are there other solutions such as VBA macros?

    Thanks

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Multiple sort in Excel

    Does Data, Subtotals meet your need? Or Data, Group & Outline, then Data, Subtotals?
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    2 Star Lounger
    Join Date
    Dec 2000
    Location
    eastern Connecticut, Connecticut, USA
    Posts
    113
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multiple sort in Excel

    This sounds like a natural for a Pivot Table. The Pivot Table wizard can be a bit intimidating at first, but between the example in Help and playing with it a bit, you should be able to build what you've described without too much difficulty.

  4. #4
    Lounger
    Join Date
    Jan 2001
    Location
    Seymour, Connecticut, USA
    Posts
    33
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multiple sort in Excel

    Gene O, thank a bunch for the pivot table hint. I knew of its existence but never tried to use it. Sorry i haven't
    replied and thanked you sooner but I had jury duty for a while and my access to the web is through work

  5. #5
    Lounger
    Join Date
    Jan 2001
    Location
    Seymour, Connecticut, USA
    Posts
    33
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multiple sort in Excel

    JohnBF, Thanks for the hint. I haven't tried your solution yet. Sorry it took me so long to thank you. I had jury duty and my access to the net is through work. I tried Gene O's idea of using a pivot table and it worked. I will try your solution next. Again thanks

Posting Permissions

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