请教大家,Excel2007,怎样用姓名首字母排序?
发布网友
发布时间：2022-04-24 23:02
共2个回答
热心网友
时间：2023-10-14 03:39
可以用辅助列的方式简单处理，假定姓名在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)将姓名的首字母列出来。然后进行排序，关键字先辅助列。追问您那个字母后面的那些字，是要按照你那个打吗？还有关键字先辅助列是什么意思呢？谢谢你了
追答排序时的关键字选通过公式得到的首字母所在列
热心网友
时间：2023-10-14 03:39
菜单里选“数据”-》排序，里面有个选项按钮，选 “笔划”排序，选确定，然后按你要升序降序排序就行
