+ Reply to Thread
Results 1 to 4 of 4

Automatic Sort Formula

  1. 08-12-2014, 06:59 AM #1
    pauldaddyadams
    pauldaddyadams is offline
    Valued Forum Contributor
    Join Date
    04-21-2005
    Location
    Southern England
    MS-Off Ver
    Excel for Office 365
    Posts
    1,702

    Automatic Sort Formula

    Hi,

    I have this formula:

    Please Login or Register  to view this content.
    Which returns unique values. Is there any way to sort this list alphabetically within the formula?
    Reply With QuoteRegister To Reply
  2. 08-12-2014, 07:07 AM #2
    noboffinme
    noboffinme is offline
    Forum Contributor noboffinme's Avatar
    Join Date
    08-29-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003/7/10/13/16/19
    Posts
    1,071

    Re: Automatic Sort Formula

    Have you looked at the SMALL or LARGE Functions?
    Remember you are unique, like everyone else
    Reply With QuoteRegister To Reply
  3. 08-12-2014, 07:13 AM #3
    pauldaddyadams
    pauldaddyadams is offline
    Valued Forum Contributor
    Join Date
    04-21-2005
    Location
    Southern England
    MS-Off Ver
    Excel for Office 365
    Posts
    1,702

    Re: Automatic Sort Formula

    I wouldnt know how to wrap the formula
    Reply With QuoteRegister To Reply
  4. 08-12-2014, 07:16 AM #4
    noboffinme
    noboffinme is offline
    Forum Contributor noboffinme's Avatar
    Join Date
    08-29-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003/7/10/13/16/19
    Posts
    1,071

    Re: Automatic Sort Formula

    Can you post your file so I can work on what you've got now?

    Thanks
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. Automatic Sort using a formula
    By pauldaddyadams in forum Excel General
    Replies: 8
    Last Post: 05-18-2012, 01:37 PM
  2. Automatic Sort A to Z Help
    By j0e_16 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-07-2010, 09:59 PM
  3. Automatic Sort
    By ferg in forum Excel General
    Replies: 2
    Last Post: 07-20-2006, 08:40 AM
  4. automatic sort
    By Robert in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  5. [SOLVED] automatic sort
    By Robert in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1