|
本帖最后由 ttbb523 于 2016-4-8 15:53 编辑
求助大神解决1,删除全是单数或者双数的行,
2,选出尾数只有一组重复且只重复2次的行
如果可以麻烦给注释下程序的详细功能
- Sub tt() '删除全是单数或者双数的行
- arr = [a1:f17]
- c = UBound(arr, 2)
- For i = 1 To UBound(arr)
- x = 0
- For j = 1 To c
- x = x + arr(i, j) Mod 2
- Next
- If x <> 0 And x <> c Then
- n = n + 1
- For j = 1 To c
- arr(n, j) = arr(i, j)
- Next
- End If
- Next
- [h1].Resize(100, c) = ""
- [h1].Resize(n, c) = arr
- End Sub
- Sub ttt() '选出尾数只有一组重复2次的行
- arr = [a1:f17]
- Set d = CreateObject("scripting.dictionary")
- c = UBound(arr, 2)
- For i = 1 To UBound(arr)
- d.RemoveAll
- For j = 1 To c
- x = arr(i, j) Mod 10
- d(x) = ""
- Next
- If d.Count = c - 1 Then
- n = n + 1
- For j = 1 To c
- arr(n, j) = arr(i, j)
- Next
- End If
- Next
- [q1].Resize(100, c) = ""
- [q1].Resize(n, c) = arr
- End Sub
复制代码
|
|