Results 1 to 16 of 16

Please HELP! Custom Sort List

Threaded View

  1. 07-29-2014, 02:21 PM #4
    Speshul
    Speshul is offline
    Valued Forum Contributor
    Join Date
    01-19-2012
    Location
    Barrington, IL
    MS-Off Ver
    Excel 2007/2010
    Posts
    1,211

    Re: Please HELP! Custom Sort List

    This might do the trick...

    Add this in a new column and sort by it

    =IFERROR(CODE(TRIM(MID(B1,FIND(" ",B1),LEN(B1)-(FIND(" ",B1)-1)))+0)+122,CODE(TEXT(TRIM(MID(B1,FIND(" ",B1),LEN(B1)-(FIND(" ",B1)-1))),"0")))

    Edit: Just realized, this won't work for double-digit or double-letter entries.... 11 will sort as 1, and AB will sort as A

    Last edited by Speshul; 07-29-2014 at 02:24 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. custom list does not sort
    By Matt Lunn in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 09-06-2005, 04:05 AM
  2. [SOLVED] Excel sort by Fill Color by custom list sort
    By Dash4Cash in forum Excel General
    Replies: 2
    Last Post: 07-29-2005, 06:05 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1