|
发表于 2016-4-1 15:00
|
显示全部楼层
本楼为最佳答案
- Sub ct()
- Dim a, b(), i%, j%, k%
- a = Array("地方A", "李四", "王五", "121212", "3333", "FS", "FS01", "AFDS")
- For j = 0 To UBound(a)
- i = 0
- For Each cell In Range("a1:z1")
- If CStr(cell.Value) = a(j) Then
- i = i + 1
- End If
- Next
- k = 0
- If i = 0 Or i > 1 Then
- k = k + 1
- ReDim Preserve b(0 To k)
- b(k) = a(j)
- End If
- Next
- Z = Application.Trim(Join(b))
- If Z = "" Then
- [a2] = "正确匹配"
- Else
- [a2] = Z
- End If
- End Sub
复制代码 |
|