|
- Sub 填充()
- Dim arr
- With Sheet1
- arr = .Range("a1").CurrentRegion.Value
- End With
- Dim arrResult(1 To 4, 1 To 4)
- Dim strRow$, strCol$
- Dim bRow As Byte, bCol As Byte, i As Byte
- strRow = "优良中差": strCol = "差中良优"
- For i = LBound(arr) + 1 To UBound(arr)
- bRow = InStr(strRow, arr(i, 2))
- bCol = InStr(strCol, arr(i, 3))
- If bRow > 0 And bCol > 0 Then arrResult(bRow, bCol) = arrResult(bRow, bCol) & arr(i, 1) & ","
- Next
- With Sheet2
- .Range("e3").Resize(UBound(arrResult), UBound(arrResult, 2)).Value = arrResult
- End With
- End Sub
复制代码 你定位出行列坐标就成了嘛。这个也不难的。
|
评分
-
查看全部评分
|