+ Reply to Thread
Results 1 to 5 of 5

Formula for Sorting in alphabetical order

  1. #1
    Forum Contributor Neilesh Kumar's Avatar
    Join Date
    05-26-2016
    Location
    INDIA
    MS-Off Ver
    2013 & 2016
    Posts
    842

    Formula for Sorting in alphabetical order

    Dear Experts,

    Please find here attached sample workbook, Where i have used the formula for the unique names in sheet1 tab (Cell C3:C28) from Raw Data tab. But the formula is not giving the alphabetically results. Can you please do provide the formula for unique values with sorting in alphabetically.

    I have kept some blank rows in Raw Data tab and i want to use them as when the new customer comes in. So i do expect that it should be also added in the unique list formula (Sheet1 Cell C3:C28) sorting with alphabetically and blank results would appear in the below after completing the alphabetical order.

    Request to you please do provide precious expertise and valuable support.

    Many thanks and kind regards,

    Neilesh

  2. #2
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Formula for Sorting in alphabetical order

    Hi Neilesh,
    Here is an array formula
    **Array formulas must be entered with Ctrl+Shift+Enter key combination.
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Please see attached file.
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Formula for Sorting in alphabetical order

    Removed by GK - incorrect formula...
    Last edited by Glenn Kennedy; 11-05-2017 at 07:28 AM.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  4. #4
    Forum Contributor Neilesh Kumar's Avatar
    Join Date
    05-26-2016
    Location
    INDIA
    MS-Off Ver
    2013 & 2016
    Posts
    842

    Re: Formula for Sorting in alphabetical order

    Dear AlKey Expert,

    Thank you for your precious phase and valuable support. The provided formula is perfectly working. Thank you so much for your valuable support Sir.

    Many thanks and kind regards,

    Neilesh
    Last edited by Neilesh Kumar; 11-05-2017 at 08:53 AM. Reason: Thread Solved

  5. #5
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Formula for Sorting in alphabetical order

    Quote Originally Posted by Neilesh Kumar View Post
    Dear AlKey Expert,

    Thank you for your precious phase and valuable support. The provided formula is perfectly working in your sample work book, but the same when i am trying to use in my workbook it is giving the blank result by using Ctrl + Shift + Enter.

    Request to you, if you please do something about it, would be appreciated.

    Many thanks and kind regards,

    Neilesh
    The only reason I could think of is mistake you made while transposing formula. However, I can't advise on the problem without seeing the spreadsheet with actual data.

+ 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. sorting letters in words into alphabetical order
    By bobf in forum Excel General
    Replies: 10
    Last Post: 10-10-2022, 01:31 AM
  2. [SOLVED] Sorting check Boxes in alphabetical order
    By sintek in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-19-2017, 04:41 AM
  3. Sorting a table into alphabetical order?
    By elliottt in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 02-21-2014, 12:57 PM
  4. Automatically sorting in to alphabetical order
    By macky18 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-15-2013, 07:45 AM
  5. Sorting the alphabetical order with semicolon in each cell.
    By spiderkzn in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-07-2012, 09:55 AM
  6. [SOLVED] Sorting Colums into alphabetical order
    By tox in forum Excel General
    Replies: 3
    Last Post: 02-22-2005, 12:06 PM
  7. Sorting rows into alphabetical order?
    By tox in forum Excel General
    Replies: 8
    Last Post: 02-04-2005, 07:08 PM

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