+ Reply to Thread
Results 1 to 2 of 2

Formula to alphabetize based on criteria

  1. #1
    Registered User
    Join Date
    10-25-2017
    Location
    United States
    MS-Off Ver
    2013
    Posts
    57

    Formula to alphabetize based on criteria

    I am looking to combine two formulas to alphabetize employee names by plan they selected. Both formulas operate exactly how I want them to, but I am hoping they can be combined without a help column if possible. Here are the formulas that I would like to combine:

    Alphabetize formula:
    Please Login or Register  to view this content.
    Criteria formula:
    Please Login or Register  to view this content.

    I have attached the workbook with the list of employee names/plan selections, desired result and the formulas above. This has also been posted to Mr. Excel:
    https://www.mrexcel.com/forum/excel-...ml#post5242367

    Thank you!
    Attached Files Attached Files
    Last edited by Stuepef; 03-13-2019 at 03:38 PM.

  2. #2
    Forum Expert XLent's Avatar
    Join Date
    10-13-2010
    Location
    Essex, UK
    MS-Off Ver
    various
    Posts
    2,575

    Re: Formula to alphabetize based on criteria

    one option

    Formula: copy to clipboard
    Please Login or Register  to view this content.

    note: above is not an array

    depending on how big your datasets are you might find above to be less than efficient... in which case I'd suggest adding some helpers, or limiting the number of calcs you do relative to count of Plan instances etc.

+ 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] Formula to alphabetize names not working
    By Stuepef in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-19-2018, 11:39 AM
  2. [SOLVED] Need formula to combine values in two columns, remove empty cells, & alphabetize.
    By Big.Moe in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-22-2017, 06:33 AM
  3. Replies: 5
    Last Post: 04-12-2016, 11:30 PM
  4. [SOLVED] Formula to Alphabetize A List, Excluding Blanks
    By JYTS in forum Excel General
    Replies: 4
    Last Post: 11-03-2015, 05:57 PM
  5. Formula to Alphabetize Names When Ties Occur
    By fearonc in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-20-2013, 01:40 PM
  6. Replies: 3
    Last Post: 03-06-2011, 05:45 PM
  7. Excel Formula to Alphabetize Unique items only from a list
    By broshannon in forum Excel General
    Replies: 3
    Last Post: 09-06-2010, 08:07 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1