请教一个排序的问题,说明在表中,能用V更好,谢谢各位指教。
eA6waUzS.rar (4.52 KB, 下载次数: 2) 2010-5-31 13:38 上传 点击文件名下载附件 请教一个排序的问题 最佳答案 月排行榜 / 总排行榜 amulee 2010-5-31 14:21 Sub 排序() Dim ArrYS, i&, j%, Temp1, Temp2, Rng As Range, Temp$ Set Rng = Range("A1:B" & Range("A65536").End(xlUp).Row) ArrYS = Rng Temp = "一二三四五六七八九十" '格式化各班级 For i = 2 To UBound(ArrYS) Temp1 = Int(InStr(1, Temp, Left(ArrYS(i, 2), 1))) Temp2 = Right(ArrYS(i, 2), Len(ArrYS(i, 2)) - 3) ArrYS(i, 2) = Temp1 * 100 + Int(Left(Temp2, Len(Temp2) - 1)) Next i Rng = ArrYS '排序。利用系统排序 Rng.Sort Key1:=Range("B2"), Order1:=xlAscending, Key2:=Range("A2") _ , Order2:=xlAscending, Header:=xlYes '恢复原来班级 ArrYS = Rng For i = 2 To UBound(ArrYS) Temp1 = Mid(Temp, ArrYS(i, 2) \ 100, 1) & "年级" ArrYS(i, 2) = Temp1 & (ArrYS(i, 2) Mod 100) & "班" Next i Rng = ArrYSEnd Sub 跳转到最佳答案楼层
使用道具 举报
自定义格式,怎么写?谢谢
本版积分规则 发表回复 回帖后跳转到最后一页
小黑屋|手机版|Archiver|Excel精英培训 ( 豫ICP备11015029号 )
GMT+8, 2024-5-16 22:16 , Processed in 0.329792 second(s), 10 queries , Gzip On, Yac On.
Powered by Discuz! X3.4
Copyright © 2001-2020, Tencent Cloud.