請測試看看,謝謝
Sub test()
Dim Arr, Brr, i&
Set xD = CreateObject("Scripting.Dictionary")
Arr = Range([g2], [g65536].End(3))
For i = 1 To UBound(Arr): xD(Arr(i, 1) & "") = 1: Next
Brr = Range([a2], [a65536].End(3))
For i = 1 To UBound(Brr): Brr(i, 1) = xD(Brr(i, 1) & ""): Next
Range("f2").Resize(UBound(Brr)) = Brr
End Sub作者: jsc0518 時間: 2021-11-22 14:57
請測試看看,謝謝
Sub test()
Dim Arr, Brr, xD, i&
Set xD = CreateObject("Scripting.Dictionary")
Arr = Range([繳庫量!g2], [繳庫量!g65536].End(3))
For i = 1 To UBound(Arr): xD(Arr(i, 1) & "") = xD(Arr(i, 1) & "") + 1: Next
With Sheets("Analysis")
Brr = .Range(.[a2], .[a65536].End(3))
For i = 1 To UBound(Brr):
If xD(Brr(i, 1) & "") > 0 Then
Brr(i, 1) = xD(Brr(i, 1) & "")
Else
Brr(i, 1) = 0
End If
Next
.Range("f2").Resize(UBound(Brr)) = Brr
End With
End Sub作者: jsc0518 時間: 2021-11-22 17:06
Sub Macro1()
Set sh = Sheets("Analysis")
With Range(sh.[A2], sh.[A2].End(xlDown))
.Offset(, 4).Formula = "=COUNTIF(繳庫量!G:G,A2)"
.Offset(, 4).Value = .Offset(, 4).Value
End With
End Sub作者: jsc0518 時間: 2021-11-23 20:12