# Formula to alphabetize last names based on criteria

#### Stuepef

##### Board Regular
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

### 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.

Replies
4
Views
48
Replies
6
Views
464
Replies
1
Views
218
Replies
3
Views
46
Replies
3
Views
318