|
发表于 2013-4-2 21:24
|
显示全部楼层
本楼为最佳答案
jinru 发表于 2013-4-2 17:39 ![](static/image/common/back.gif)
谢谢,完全符合,
但有个要求,能否用两个参数,因为可能A4单元格和D4单元格比较,隔了一列或一行,
谢谢 - Function TQBT(RNG1, RNG2)
- arr1 = Split(RNG1, ",")
- arr2 = Split(RNG2, ",")
- For i = 0 To UBound(arr1)
- y = False
- For j = 0 To UBound(arr2)
- If arr1(i) = arr2(j) Then
- y = True
- Exit For
- End If
- Next j
- If y = False Then s = s & arr1(i) & ","
- Next i
- TQBT = Left(s, Len(s) - 1)
- End Function
复制代码
298395-VBA-自定义函数-提取不同-1.rar
(12.82 KB, 下载次数: 250)
|
|