+ Reply to Thread
Results 1 to 4 of 4

Automatic Sorting

  1. #1
    Registered User
    Join Date
    06-12-2012
    Location
    Colorado
    MS-Off Ver
    Excel 2010
    Posts
    6

    Automatic Sorting

    Hi All,

    Thank you in advance for all the great tips. This site is amazing.

    I have a column where I created a drop list with the options recent, completed, and also a blank field option. I need excel to automatically sort this. When recent is selected that row moves to the top, when completed is selected it moves to the bottm, and the blank field goes in the middle. What is the best way to achieve this goal?

    Thanks!

    Summer

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,311

    Re: Automatic Sorting

    if you dont mind a helper column, you could use a formula (or an entry) to have all "recent" marked as 1, all "blank" ad 2 and all "complete" as 3. then sort based on that column

    with your values in A1 downwards, use this formula in the helper, copied down...

    =IF(A1="recent",1,IF(A1="Complete",2,3))

    let me know how this works for you?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    06-12-2012
    Location
    Colorado
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Automatic Sorting

    Hi FDibbins,

    Thank you for the fast response. I am not sure I follow what you are suggesting. By giving them numerical value, they will sort automatically and in order as we use that column? There will be multiple times the value will be the same, for example right now I already have 5 completed projects on the spreadsheet, multiple recent projects, and several projects in limbo which we leave that column blank. Will excel get confused?

    Thanks!

    Summer

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,311

    Re: Automatic Sorting

    aahh sorry, missed the "automatic" part, sorry. no this wont sort automatically, at least not on its own. you could make up a small macro that will do this for you tho, and then add a button to click-to-sort based on the helper column

+ 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