|
发表于 2015-4-15 16:52
|
显示全部楼层
本楼为最佳答案
换个不用字典的思路,纯字符串比较- Sub 不用字典()
- arr = Range("a1:c" & [a65536].End(3).Row)
- For i = 2 To UBound(arr)
- s = ""
- For k = 1 To 2
- t = IIf(k = 1, 2, 1)
- x = arr(i, k)
- xrr = Split(x, ",")
- For m = 0 To UBound(xrr)
- y = "," & xrr(m) & ","
- If InStr("," & arr(i, t) & ",", y) = 0 Then s = s & "," & "数据" & k & "的" & xrr(m) & "在数据" & t & "未找到"
- Next
- Next
- If s = "" Then s = ",相等"
- arr(i, 3) = Mid(s, 2)
- Next
- [a7].Resize(UBound(arr), UBound(arr, 2)) = arr
- End Sub
复制代码 |
|