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:
Criteria Formula (plan 1):
Employee List & Plan:
<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
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:
Employee | Plan Selection | |
<tbody> </tbody> | 3 | |
<tbody> </tbody> | 1 | |
<tbody> </tbody> | 1 | |
<tbody> </tbody> | 2 | |
<tbody> </tbody> | 3 | |
<tbody> </tbody> | 1 | |
<tbody> </tbody> | 1 | |
<tbody> </tbody> | 3 | |
<tbody> </tbody> | 2 | |
<tbody> </tbody> | 2 | |
<tbody> </tbody> | 1 | |
<tbody> </tbody> | 3 | |
<tbody> </tbody> | 2 | |
<tbody> </tbody> | 2 | |
<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