Advanced filter unique do not working properly.

[Ferreira1456]

For some reason advanced filter unique do not working properly.

Could you please help me?
Please take at look on my Macro and show me where is the problem. One of the error is the very first one.
Public Sub CustomerList()

Dim rngData As Range
Dim lin As Long
Dim li As ListItem

Sheet1.Select

With Sheet1
Set rngData = .Range("B2:C" & .Range("B" & Rows.Count).End(xlUp).Row)
rngData.AdvancedFilter Action:=xlFilterCopy, _
CopyToRange:=.Range("AA1"), _
Unique:=True

lin = 1
Do While .Cells(lin, "AA") <> ""
Set li = UserFormCustomer.listvBetweenDates.ListItems.Add(Text:=" ")
li.ListSubItems.Add Text:=.Cells(lin, "AA").Value
li.ListSubItems.Add Text:=.Cells(lin, "AB").Value
lin = lin + 1
Loop
.Range("AA1:AB" & .Range("AA" & Rows.Count).End(xlUp).Row + 1).ClearContents
.Cells(1, 1).Activate
End With

 

[Anthony47]

Hi Anthony47. Thank you very much for your help.
like you said,Excel don't fail... So The only thing I need on the entire line is columns B and C are exactly the same [. . .]

I did not understand if you discovered the small difference on the lines that look duplicated ("Excel don't fail") or it is still unclear ("B and C are exactly the same")

If it is still unclear, use the formula

=FirstValue=OtherValueThatLooksDuplicated

Example =AA2=AA12
If the result is True (on both columns) then... even Excel fails; I would be interested in looking at your table of data and see how the macro fails

By the way, clear Range("AA:AB") before populating them with the (pseudo)unique records (to be sure that there is not a remnant of a previous extraction)

Bye

 

[Ferreira1456]

I have complicates the question. I need that Excel search the unique value at column "A" and the unique value at column "B". In column "A" I have the Account Number "1234" and "B" I have the Customer Name "Microsoft"

 

[Anthony47]

I am not sure about your request... If you can get unique values from two columns, with the same approach you can get unique values from single columns...
Could you share a sample workbook with sample data and, based on those data specify which output you would expect?
To share a file please use a file sharing service, like dropbox.com or filedrop.com

Bye