世界杯预选赛亚洲区_高达世界杯 - fzxzyy.com

本帖最后由 良良 于 2024-6-2 21:46 编辑

dublove 发表于 2024-6-2 19:59

这不影响以B列以音序排序吧，我是用来做索引的……索引一般应该以第一个字音序升序排，若一相同，以第二 ...

？

C2=IF(B2<"吖",B2,VLOOKUP(B2,{"","";"吖","A";"八","B";"嚓","C";"咑","D";"鵽","E";"发","F";"猤","G";"铪","H";"夻","J";"咔","K";"垃","L";"嘸","M";"旀","N";"噢","O";"妑","P";"七","Q";"囕","R";"仨","S";"他","T";"屲","W";"夕","X";"丫","Y";"帀","Z"},2)&CODE(MID(B2,1,1))&IFERROR(CODE(MID(B2,2,1)),"")&IFERROR(CODE(MID(B2,3,1)),""))复制代码

image.png (24.89 KB, 下载次数: 105)

下载附件

保存到相册

2024-6-2 21:46 上传