Hi Christian
Welcome to the Forum!
The Advanced filter requires a header. Since you're starting on row 2, it treats row 2 as the header row...therefore you get it twice. Your best bet, if you don't want the header row is to include it in your filter range then delete it.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
Hi all thanks for the help.
Unfortunately, the advanced filter option with uniqie records results in the same repetition of the first value, even if I include the "Internal_PN" header row in the selection and even if I delete it. It just does not work...
However, the solution provided by Fortis is just great! Particularly because it would allow me to obtain the list of unique records in a different sheet, which the Advanced Filter option does not allow.
Thanks!
I still don't understand why the Advanced Filter does not work as expected...
Regards,
Cristian
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks