excel数据按A列排序(A列不动,B列和A列车牌相同,B列按照A列排序,其他列跟随B列)
=INDEX(B$1:B$20,MOD(SMALL(IFERROR(MATCH($B$1:$B$20,$A$1:$A$20,),99)*100+ROW($A$1:$A$20),ROW(A1)),100))&""
热门标签:
=INDEX(B$1:B$20,MOD(SMALL(IFERROR(MATCH($B$1:$B$20,$A$1:$A$20,),99)*100+ROW($A$1:$A$20),ROW(A1)),100))&""