|
本帖最后由 青春白开水 于 2016-5-28 22:55 编辑
如题:怎样多条件找出多组一正一负的数据 ?
,最好是简单易操作的方法,请大家帮忙啊~有附件
- Sub Macro1()
- Dim arr, d, i&
- Set d = CreateObject("scripting.dictionary")
- arr = Range("a1").CurrentRegion
- For i = 2 To UBound(arr)
- zf = arr(i, 1) & "," & arr(i, 2) & "," & Abs(arr(i, 3))
- If Not d.exists(zf) Then
- d(zf) = i
- Else
- n = d(zf)
- If arr(n, 3) + arr(i, 3) = 0 Then
- Cells(i, 4) = n: Cells(n, 4) = i: d.Remove (zf)
- End If
- End If
- Next
- End Sub
复制代码
|
|