如何创建自定义排序
我正在研究一个数据，我需要使用Google Sheet公式进行自定义排序，
即我的预期输出，首先是类别需要显示的库存，然后是Transit＆amp;不是建造的，这是因为库存是一个类别，而Tranist＆amp;不是构建的是另一个类别，也将按升序顺序排列。基本上，所有库存始终都需要处于最高状态，然后运输又不按上升顺序建造。
这是我尝试使用以下公式的尝试，但这并不是
=SORT(ARRAYFORMULA(Raw_Data!X2:AG1000),27,TRUE,MATCH(Raw_Data!Y2:Y,{"IN STOCK";"TRANSIT";"NOT BUILT"},0),TRUE)
我在这里没有搜索过的，而是我无法找到我想要的确切分辨率，我可能无法理解，我已经尝试了这么长时间，甚至在Google上进行了搜索，尝试使用查询功能，但我仍然无法解决，任何建议或建议都受到欢迎和高度赞赏。
I am working on a data where I need to do a custom sort using google sheet formula,
i.e my expected output, is first the category needs to show IN STOCK, then the TRANSIT & NOT BUILT, this is because IN STOCK is one category while TRANIST & NOT BUILT is another category, also the MDL will be in ascending order. Basically all the IN STOCK always needs to be on top, and then the TRANSIT followed by NOT BUILT in ascending order.
This is what I have tried using the following formula, but it doesn't works
=SORT(ARRAYFORMULA(Raw_Data!X2:AG1000),27,TRUE,MATCH(Raw_Data!Y2:Y,{"IN STOCK";"TRANSIT";"NOT BUILT"},0),TRUE)
Not that i have not searched here, but i am not able to locate the exact resolution which i am looking for may be i am not able to understand, I have been trying for so long, even searched on google, tried using the QUERY function but still i am not able work that out, any suggestions or advices is welcomed and highly appreciated.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
尝试：
try: