+ Reply to Thread
Results 1 to 7 of 7

Sorting list by number contained in same cell as name?

  1. #1
    Registered User
    Join Date
    03-07-2008
    Posts
    4

    Sorting list by number contained in same cell as name?

    Hi, I created a list with names and after each name a difficulty.
    Easy, Normal, Hard and Brutal.
    It looks something like this

    Name 1 HARD
    Name 2 EASY
    Name 3 EASY
    Name 4 BRUTAL
    Name 5 HARD
    .. etc


    I want to be able to sort the second colum (difficulty), not alphabetically, but in order of their value.
    So: Easy, Normal, Hard, Brutal
    Or: Brutal, Hard, Normal, Easy

    I can only arrange them alphabetically, can anyone help me?

    Thanks,
    cxn

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    You can't Sort like hat. You need to add a "helper column" and assign a numerical value to each difficulty eg 4 for Brutal, 1 for Easy, then sort by the helper column.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    03-07-2008
    Posts
    4
    Quote Originally Posted by royUK
    You can't Sort like hat. You need to add a "helper column" and assign a numerical value to each difficulty eg 4 for Brutal, 1 for Easy, then sort by the helper column.

    Oh damn That'd make my spreedsheet ugly :p

    How would I be able to link them?

    1=easy
    2=normal
    etc..

    I guess in 1 column?

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    You can hide the helper column when not required.

  5. #5
    Registered User
    Join Date
    03-07-2008
    Posts
    4
    Quote Originally Posted by royUK
    You can hide the helper column when not required.
    Oh cool ^_^

    How do I make that helper column though?

  6. #6
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229
    Another approach is to use Options to create a custom list and sort by that order.
    Tools>Options>CustomList
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

  7. #7
    Registered User
    Join Date
    03-07-2008
    Posts
    4
    It worked! Thanks to both
    Last edited by cxn; 03-07-2008 at 03:48 PM.

+ 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