In Excel, I’m trying to generate a list of students who qualify for specific services but are not receiving them. I’ve been able to write a formula which returns the students that should get the specific services, a formula which lists all students getting the specific service, and a MATCH formula which then lists the students who should get the service but are not. The lasts step of this, which I can’t figure out, is how to add to the formula (or write a formula in a new column) which automatically sorts the list alphanumerically and without empty cells, like this:

image of what I’m trying to do

I’m all good to the third column, but I can’t figure out how to make the results look like they do in the forth column automatically. I’d appreciate any suggestions.

Sorry, was trying to insert a table instead of a picture, but kept getting an error about code formatting.