Results 1 to 2 of 2

Formula to alphabetize based on criteria

Threaded View

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

    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:
    =IFERROR(INDEX(A$2:A$96,MATCH(ROWS(A$2:A2),INDEX(COUNTIFS(A$2:A$96,"> ",A$2:A$96,"<="&A$2:A$96),0),0)),"")
    Criteria formula:
    {=IFERROR(INDEX($A$2:$A$16,SMALL(IF($B$2:$B$16=1+0,ROW($A$2:$A$16)-(ROW($A$2)-1)),ROWS($2:2))),"")}

    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.

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