|
本帖最后由 我行我速2008 于 2022-8-23 12:23 编辑
没附件,未经测试,试试吧!以后求助贴一定要上传附件!!
Sub tt()
Dim Ar, Br(), R&, X&, K&
Dim Sh As Worksheet
For Each Sh In Worksheets
With Sh
.Columns("D:E").ClearContents
Ar = .[a1].CurrentRegion
For R = 1 To UBound(Ar) - 1
For X = R + 1 To UBound(Ar)
If Abs(Ar(R, 2) - Ar(X, 2)) < 0.01 Then
If Abs(Ar(R, 1) - Ar(X, 1)) < 0.05 Then
Ar(X, 1) = 0: Ar(X, 2) = 0
End If
End If
Next X
Next R
For R = 1 To UBound(Ar)
If Ar(R, 1) <> 0 Then
K = K + 1
ReDim Preserve Br(1 To 2, 1 To K)
Br(1, K) = Ar(R, 1)
Br(2, K) = Ar(R, 2)
End If
Next R
.[d1].Resize(K, 2) = Application.Transpose(Br)
Erase Br
K = 0
End With
Next Sh
End Sub |
|