公式以产生alpha数字列表，没有另一列的空格
在Excel中，我正在尝试生成有资格获得特定服务但没有收到这些服务的学生的列表。我已经能够编写一个公式，该公式将返回应该获得特定服务的学生，一个公式，列出了所有获得特定服务的学生，以及一个匹配公式，然后列出了应该获得服务但没有获得服务的学生。我不知道的最后一步是如何将其添加到公式（或在新列中编写公式），该公式会自动按字母数字和无空单元格进行列表，例如：
我对第三列我都很好，但我不知道找出如何使结果看起来像在第四列自动中所做的。我感谢任何建议。
抱歉，试图插入表而不是图片，但一直遇到有关代码格式的错误。
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 last 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 fourth 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.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
前提这些天大多数人），您可以使用
unique，sort和filter函数。在单元D2中尝试此公式：
如果您不使用具有此功能的Excel版本，那么您将没有很多选项，而无需拖动公式并执行一些奇怪的Texjoin变电站方法。大多数Excel版本确实具有此功能，就像Excel的Web版本和Google表（同一公式在这些平台上都可以使用）。
Assuming you're on Excel with a spill range (most people are these days), you can use the
unique,sort, andfilterfunctions.Try this formula in cell D2:
If you aren't on a version of Excel that has this, you don't have a lot of options without dragging a formula and doing some odd Texjoin substation method. Most Excel versions do have this functionality as does Excel's Web version and Google Sheets (same formula would work on these platforms).