+ Reply to Thread
Results 1 to 4 of 4

Formula That Horizontal Sorts in Alphabeticaal Order

  1. #1
    Forum Contributor
    Join Date
    06-16-2008
    Posts
    115

    Formula That Horizontal Sorts in Alphabeticaal Order

    I'm working with a sheet where I need to horizontal sort (left to write) multiple rows alphabetically.

    Example
    Phrase Word1 Word2 Word3
    mobile rewards apps rewards apps mobile

    Desired Output
    Phrase Word1 Word2 Word3
    mobile rewards apps apps mobile reward


    Mike Girvin has a Youtube video: https://www.youtube.com/watch?v=RojHISXA2gM - He gets the job done on numbers using LARGE & COLUMNS. In my case, I would need to use SMALL. However LARGE & SMALL only work on numbers and not text.

    Is there another Excel formula that would give me the desired output? Keep in mind, I might need to sort at least 10 columns and a few thousand rows.

    Many thanks in advance!

  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 That Horizontal Sorts in Alphabeticaal Order

    Try this
    Enter formula in E1 and copy across
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    v A B C D E F G
    1 rewards apps mobile apps mobile rewards
    Last edited by AlKey; 09-16-2016 at 10:11 PM.
    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 Contributor
    Join Date
    06-16-2008
    Posts
    115

    Re: Formula That Horizontal Sorts in Alphabeticaal Order

    Great Job, AlKey.

    I was getting the desired result at first, but I figured out it was due to untrimmed spaces in the cell. I'm assuming that I can adjust the range to accommodate for the number of columns that need to be sorted?

    Once again, thanks so much for your help. I really appreciate it!

  4. #4
    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 That Horizontal Sorts in Alphabeticaal Order

    You're welcome. Please don't forget to thank those who helped by clicking on Add Reputation * and please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).

+ 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. [SOLVED] Custom List Sorts Out of Order
    By LucasTanner in forum Excel General
    Replies: 2
    Last Post: 10-12-2012, 09:41 AM
  2. Replies: 1
    Last Post: 06-15-2012, 03:57 AM
  3. Order horizontal lines by skipping empty cells
    By Hitch75 in forum Excel General
    Replies: 4
    Last Post: 09-07-2010, 05:24 PM
  4. Linking Cells so sorts of one columb sorts another
    By excellerator22 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 04-12-2008, 11:26 PM
  5. Macro Sorts In Wrong Order
    By dave6726 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-27-2007, 04:20 PM
  6. [SOLVED] Need a spreadsheet that sorts by month/yr & 2 other sorts w/total
    By Spreadsheet in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-19-2006, 09:45 AM
  7. Replies: 1
    Last Post: 03-28-2005, 09:06 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