|
xingel 发表于 2016-6-22 17:19
感谢baksy的公式,感谢dsmch。
dsmch,若非专业成绩低于该类D档线,其综合等级中“ABCD”会继承上一个的AB ... - Sub TJ()
- Dim Sht As Worksheet, Rng As Range
- Dim Arr, Bz$
- Arr = Sheet2.[a1].CurrentRegion: brr = Sheet1.[a1].CurrentRegion
- Set Sht = Sheets("sheet1")
- For i = 2 To UBound(Arr)
- Set Rng = Sht.Columns(1).Find(Arr(i, 3), , , xlWhole)
- If Arr(i, 4) >= Sht.Cells(Rng.Row, 2) Then Bz = "X"
- For j = 1 To 4
- If Arr(i, 5) >= brr(Rng.Row, j + 2) Then Zy = Chr(69 - j)
- Next
- Cells(i, 7) = Zy & Bz
- Zy = "": Bz = ""
- Next
-
- End Sub
复制代码 |
评分
-
查看全部评分
|