Array formula to return table column values, alpha sorted

I'm have a table, 'EmpTable,' which contains employee names in column B, '[Employee]', and a named range of EmpList, which =EmpTable[Employee]. The table has headers so the first name appears on B2. But the table needs sorted by another column criteria, so the names are not alphabetical in the table, which I also need.

In trying to get a list of the names alpha-sorted that will update when changes are made to the table, and I have the following all array formula on another sheet (beginning on A2 of that sheet):

Formula:

Please Login or Register  to view this content.

This works great except it leaves off the last (alpha) name from the list! For example, the table has 288 names, but the formula, copied down to row 300, returns 287 names, and the 1 left off is the last name by the alpha-sort.

As it turns out, my array formula (it was an array too, I know all about them, btw), should've been =IF(COUNTA(EmpList)>=+ROWS($B$2:B2) in the first portion, instead of only =...(EmpList)>+ROWS... so mine is actually working correctly now, I just forgot to post it.

But yours works too! Thank you!!

Yes, now, just for fun, I'm looking at the difference between the 2... mine uses COUNTA, ROWS, INDEX, MATCH, SMALL, COUNTIF (twice) and ROW... while your first one uses IFERROR, INDEX, MATCH, COUNTIF (twice) and SUM. What I'm wondering is if - since yours is shorter and uses less functions - if it's marginally quicker or more stable?