Sub LocNhieuDK()
Dim ParkHangSeo As Object, Key As String
Dim VietNam(), HanQuoc(), I As Long, K As Long
Set ParkHangSeo = CreateObject("Scripting.Dictionary")
With Sheets("Dulieu")
VietNam = .Range("E2", .Range("E" & Rows.Count).End(3)).Resize(, 19).Value
End With
ReDim HanQuoc(1 To UBound(VietNam, 1), 1 To 5)
For I = 1 To UBound(VietNam, 1)
Key = VietNam(I, 1) & "@@@" & VietNam(I, 19)
If Not ParkHangSeo.Exists(Key) Then
K = K + 1
ParkHangSeo.Add Key, K
HanQuoc(K, 1) = K
HanQuoc(K, 2) = VietNam(I, 1)
HanQuoc(K, 3) = VietNam(I, 18)
HanQuoc(K, 4) = VietNam(I, 19)
HanQuoc(K, 5) = "=RC[-2]*RC[-1]"
Else
HanQuoc(ParkHangSeo.Item(Key), 3) = HanQuoc(ParkHangSeo.Item(Key), 3) + VietNam(I, 18)
End If
Next I
With Sheets("Ketqua")
.Range("H3").Resize(K, 5) = HanQuoc
End With
Set ParkHangSeo = Nothing
End Sub