Sub test()
Dim A, r, i, j
A = [B2:Z30]: r = UBound(A)
For j = 1 To UBound(A, 2)
For i = 1 To r - 4
If VBA.IsNumeric(A(i, j)) Then
If A(i, j) < A(r, j) Then
A(i, j) = A(r, j) - A(i, j)
A(i, j) = "<" & Format(A(i, j), "0.000")
End If
End If
Next i
Next j
[b2].Resize(r, j - 1) = A
End Sub
data2.rar
(12.59 KB, 下载次数: 8)
|