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!
Bookmarks