|
- Sub lqxs()
- Dim Arr, i&, j&, y&, a$, d
- Set d = CreateObject("Scripting.Dictionary")
- Sheet1.Activate
- [b:b].ClearContents
- Arr = [a1].CurrentRegion
- For i = 1 To UBound(Arr) - 1
- For y = 1 To Len(Arr(i, 1))
- a = Mid(Arr(i, 1), y, 1)
- If d.exists(a) Then
- GoTo 100
- Else
- d(a) = ""
- End If
- Next
- k = d.keys
- For j = i + 1 To UBound(Arr)
- For y = 0 To UBound(k)
- If InStr(Arr(j, 1), k(y)) = 0 Then GoTo 100
- Next
- Cells(j, 2) = 1
- Next
- 100:
- d.RemoveAll
- Next
- End Sub
- Sub lqxs2()
- Dim Arr, i&, j&, y&, a$, d, n&
- Set d = CreateObject("Scripting.Dictionary")
- Sheet2.Activate
- [b:b].ClearContents
- Arr = [a1].CurrentRegion
- For i = 1 To UBound(Arr) - 1
- For y = 1 To Len(Arr(i, 1))
- a = Mid(Arr(i, 1), y, 1)
- d(a) = ""
- Next
- If d.Count < 4 Then GoTo 100
- k = d.keys
- For j = i + 1 To UBound(Arr)
- n = 0
- For y = 0 To UBound(k)
- If InStr(Arr(j, 1), k(y)) Then
- n = n + 1
- End If
- Next
- If n = 4 Then Cells(j, 2) = 1
- Next
- 100:
- d.RemoveAll
- Next
- End Sub
复制代码 |
评分
-
查看全部评分
|