+ Reply to Thread
Results 1 to 1 of 1

Data Sort by Drop Down List

  1. #1
    Registered User
    Join Date
    03-25-2011
    Location
    Oakville, Canada
    MS-Off Ver
    Excel 2003
    Posts
    12

    Data Sort by Drop Down List

    Hi All,

    Looking for some help with the attached spread sheet. I copied a previous spread sheet used for similiar data analysis however I'm having a trouble with the IF statements in the 'Month' chart which would ultimately sort my data. I need to sort by Month (including YTD), by Quarter (Including Full Year), and by Individual (1,2,3.. Team). This is a bit beyond my abilities in excel so any help would be of great assistance. Please let me know if you need further clarification, as I'm not sure If I explained this clearly. Thanks in advance...

    Update: I have figured out how to sort by Quarter... Am I not able to sort by more then one factor? Will I have to create another chart to sort by UW? Thanks
    Attached Files Attached Files
    Last edited by turpink; 05-19-2011 at 11:33 AM.

+ Reply to Thread

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