Formula to alphabetize last names based on criteria

Stuepef

Board Regular
Joined
Oct 23, 2017
Messages
110
I have a list of employee last names that I would like to alphabetize based on the plan chosen. I created the alphabetize formula and the criteria formula, but need assistance combining them if possible:

Alphabetize formula:
Code:
[COLOR=#333333]=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)),"")[/COLOR]

Criteria Formula (plan 1):
Code:
[COLOR=#333333]{=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))),"")}[/COLOR]

Employee List & Plan:
EmployeePlan Selection
Richards

<tbody>
</tbody>
3
Cone

<tbody>
</tbody>
1
Flairty

<tbody>
</tbody>
1
Hector

<tbody>
</tbody>
2
James

<tbody>
</tbody>
3
Paige

<tbody>
</tbody>
1
William

<tbody>
</tbody>
1
Wood

<tbody>
</tbody>
3
Rose

<tbody>
</tbody>
2
Maggie

<tbody>
</tbody>
2
Sharon

<tbody>
</tbody>
1
Jesse

<tbody>
</tbody>
3
Lori

<tbody>
</tbody>
2
Kim

<tbody>
</tbody>
2
Jason

<tbody>
</tbody>
3

<tbody>
</tbody>



The sample workbook and employee information was posted at Excel Help Forum at: https://www.excelforum.com/excel-fo...lphabetize-based-on-criteria.html#post5082582
 

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

Watch MrExcel Video

Forum statistics

Threads
1,108,910
Messages
5,525,587
Members
409,652
Latest member
strangelyangely

This Week's Hot Topics

Top