Results 1 to 5 of 5

Excel 2007 - How to sort results of previous sort without changing data order

Threaded View

  1. #1
    Registered User
    Join Date
    11-20-2012
    Location
    Houston, TX
    MS-Off Ver
    Excel 2007-2010
    Posts
    3

    Excel 2007 - How to sort results of previous sort without changing data order

    Sorry if that was not clear. i have monthly report from CRM that needs to be sorted by customer, then sorted by date while maintaining customer groupings.

    I have tried sorting by name, then by date, but I end up with names grouped in order A-Z, and dates within groups of the same name sorted oldest to new. What I really need is data sorted by date with all like customer names grouped together and sorted by date within the like customer names.


    I have attached example of before and desired results. Thanks in advance for your assistance.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1