+ Reply to Thread
Results 1 to 3 of 3

Order / sort range by number in bracket first then remainder alphabetically.

  1. #1
    Forum Contributor
    Join Date
    09-11-2008
    Location
    uk
    MS-Off Ver
    2010; 2016
    Posts
    390

    Order / sort range by number in bracket first then remainder alphabetically.

    All,

    Stuck again!!!

    I've got a range B3:B267, where previous sheets calculations will place names combined with numbers enclosed in brackets....the brackets are always at the beginning of the cell and there are no repeated numbers.

    I have managed to work some code (triggered by the button which will send these calculated values to text and remove the blanks), but I cant seem to get the sort right in column D. What I want to happen is for the values in brackets to go to top of the sort.....and sorted numerically and then the remainder sorted alphabetically. I attach a demo file for you to have a look at.

    Thanks for looking.

    Skyping
    Attached Files Attached Files
    Last edited by skyping; 08-25-2013 at 07:29 AM.

  2. #2
    Forum Contributor
    Join Date
    09-11-2008
    Location
    uk
    MS-Off Ver
    2010; 2016
    Posts
    390

    Re: Order / sort range by number in bracket first then remainder alphabetically.

    Sorted it myself!!!

    Final code below:

    Please Login or Register  to view this content.
    SOLVED

  3. #3
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Order / sort range by number in bracket first then remainder alphabetically.

    Are you sure?

    If the data looks like

    123Jeff
    (1)trevor
    (12) Paul
    zzz
    Ff
    Head
    (2) Masa

    Will be sorted like

    (1)trevor
    (12) Paul
    (2) Masa
    123Jeff
    Ff
    Head
    zzz

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 07-10-2013, 03:19 PM
  2. Put in Alphabetically Order as You Enter
    By kuzna26 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-13-2013, 05:26 AM
  3. Help with math bracket calculation order
    By ronlaboa in forum Excel General
    Replies: 3
    Last Post: 12-12-2012, 04:58 AM
  4. Alphabetically Order list
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-15-2010, 06:56 PM
  5. Excel 2007 : Sort a dynamic range alphabetically
    By lmsexcelforum in forum Excel General
    Replies: 2
    Last Post: 01-26-2009, 11:42 AM

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