@hongphuong1997
Option Explicit
Function LocKQ(chuoiKq, chuoiNguon, dk)
Dim Tam
Dim Kq()
Dim i, j, k
Tam = Split(chuoiKq, ";")
ReDim Kq(UBound(Tam))
For Each k In Split(chuoiNguon, ";")
If k = dk Then
Kq(j) = Tam(i)
j = j + 1
End If
i = i + 1
Next k
LocKQ =...