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:
Criteria formula:Please Login or Register to view this content.
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!
Bookmarks