Advanced Filter includes duplicates while creating unique list

[AZ-XL]

Hi Excel Experts.

I have table and trying to create unique list using Advanced Filter. But Excel gives me duplicate value of the one Customer.
Can anyone tell me why excel behaves like that. Actually I am trying to create VBA codes on this but it gives me same result too.
Uploading file and my result. The problem shown in red letters.

Thank you all in advance.

[hemesh]

Try Convert your list to table then use advanced filter from the header then it will give you header name and only unique values


or select table from C1:C281 I think you are selecting it from C2 and Down.

[AZ-XL]

I think you are selecting it from C2 and Down.

You are right. I was selecting from c2 cell. I did as you said and it works. In my previous list Excel was considering one of the name as a header. I got it now.
Thank you very much for your effort and advice.

[hemesh]

You are welcome and Thanks for the feedback !

[Tony Valko]

You might be interested in this:

Use an event macro to extract unique entires