|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
yzyyyyyyy 发表于 2014-12-26 10:14
感谢大师热心帮助。请大师把其余的5个也做成示例,我
再学写折算分,总分的。
学科分级序 学 ...
请测试- Sub aa()
- R = Range("a" & Rows.Count).End(xlUp).Row
- arr = Range("a2:f" & R)
- brr = YjhSort(arr, "1,2", "1,5", "R,-5;1;2") '学科分班名
- Range("h2").Resize(UBound(brr), UBound(brr, 2)) = brr
- brr = YjhSort(arr, "1,2", "1,5", "R,-5;1;1") '学科分班序
- Range("j2").Resize(UBound(brr), UBound(brr, 2)) = brr
- 'brr = YjhSort(arr, "1,2", "1,5", "R,-5;1;2,-5;1;1") '学科分班名、学科分班序
- 'Range("L2").Resize(UBound(brr), UBound(brr, 2)) = brr
- brr = YjhSort(arr, "-1", "5", "R,0--5;1;12") '学科分级名
- Range("i2").Resize(UBound(brr), UBound(brr, 2)) = brr
- brr = YjhSort(arr, "-1", "5", "R,0--5;1;11") '学科分级序
- Range("k2").Resize(UBound(brr), UBound(brr, 2)) = brr
- brr = YjhSort(arr, "1,2", "1,5", "R,5;1;2") '学科分班倒名
- Range("L2").Resize(UBound(brr), UBound(brr, 2)) = brr
- brr = YjhSort(arr, "1,2", "1,5", "R,5;1;1") '学科分班倒序
- Range("n2").Resize(UBound(brr), UBound(brr, 2)) = brr
- 'brr = YjhSort(arr, "1,2", "1,5", "R,5;1;2,5;1;1") '学科分班倒名、学科分班倒序
- 'Range("L2").Resize(UBound(brr), UBound(brr, 2)) = brr
- brr = YjhSort(arr, "1", "5", "R,0-5;1;12") '学科分级倒名
- Range("m2").Resize(UBound(brr), UBound(brr, 2)) = brr
- brr = YjhSort(arr, "1", "5", "R,0-5;1;11") '学科分级倒序
- Range("o2").Resize(UBound(brr), UBound(brr, 2)) = brr
- End Sub
复制代码 折算分 5改6
总分 5改4
输出相应改 |
|