Ban chay ham nay nhe.Nhờ các bạn trợ giúp bài như file đính kèm
Function laydulieu(ByVal dk As Range, ParamArray mang() As Variant)
Dim dic As Object, T, T1, dks As String, arr(1 To 1000, 1 To 1), a As Integer
Set dic = CreateObject("scripting.dictionary")
For Each T In dk
dks = T.Value
If Not dic.exists(dks) Then
dic.Add dks, "KK"
End If
Next
For Each T In mang
For Each T1 In T
dks = T1.Value
If Not dic.exists(dks) Then
a = a + 1
arr(a, 1) = dks
dic.Add dks, "KK"
End If
Next
Next
Set dic = Nothing
laydulieu = arr
End Function
=laydulieu(A1:A20,'2'!A1:A20,'3'!A1:A20)
Cảm ơn bạn @snow25 công thức quá tuyệt vờiBan chay ham nay nhe.
Mã:Function laydulieu(ByVal dk As Range, ParamArray mang() As Variant) Dim dic As Object, T, T1, dks As String, arr(1 To 1000, 1 To 1), a As Integer Set dic = CreateObject("scripting.dictionary") For Each T In dk dks = T.Value If Not dic.exists(dks) Then dic.Add dks, "KK" End If Next For Each T In mang For Each T1 In T dks = T1.Value If Not dic.exists(dks) Then a = a + 1 arr(a, 1) = dks dic.Add dks, "KK" End If Next Next Set dic = Nothing laydulieu = arr End Function
Mã:=laydulieu(A1:A20,'2'!A1:A20,'3'!A1:A20)
DIỄN ĐÀN GIẢI PHÁP EXCEL Group 1
DIỄN ĐÀN GIẢI PHÁP EXCEL Group 2