请教大家，Excel2007,怎样用姓名首字母排序？

发布网友发布时间：2022-03-27 09:38

共2个回答

热心网友时间：2022-03-27 11:07

可以用辅助列的方式简单处理，假定姓名在A列，从A2开始，你找一空白列输入公式
=VLOOKUP(A2,{"","";"吖","A";"八","B";"嚓","C";"咑","D";"鵽","E";"发","F";"猤","G";"铪","H";"夻","J";"咔","K";"垃","L";"呒","M";"旀","N";"噢","O";"妑","P";"七","Q";"囕","R";"仨","S";"他","T";"屲","W";"夕","X";"丫","Y";"帀","Z"},2)&VLOOKUP(MID(A2,2,1),{"","";"吖","A";"八","B";"嚓","C";"咑","D";"鵽","E";"发","F";"猤","G";"铪","H";"夻","J";"咔","K";"垃","L";"呒","M";"旀","N";"噢","O";"妑","P";"七","Q";"囕","R";"仨","S";"他","T";"屲","W";"夕","X";"丫","Y";"帀","Z"},2)&VLOOKUP(MID(A2,3,1),{"","";"吖","A";"八","B";"嚓","C";"咑","D";"鵽","E";"发","F";"猤","G";"铪","H";"夻","J";"咔","K";"垃","L";"呒","M";"旀","N";"噢","O";"妑","P";"七","Q";"囕","R";"仨","S";"他","T";"屲","W";"夕","X";"丫","Y";"帀","Z"},2)将姓名的首字母列出来。然后进行排序，关键字先辅助列。追问您那个字母后面的那些字，是要按照你那个打吗？还有关键字先辅助列是什么意思呢？谢谢你了

追答排序时的关键字选通过公式得到的首字母所在列

热心网友时间：2022-03-27 12:25

菜单里选“数据”-》排序，里面有个选项按钮，选 “笔划”排序，选确定，然后按你要升序降序排序就行