Macros and advanced filter

I want an automated way of running an advanced filter, when i run the filter it will automatically count how many times the entry was listed.When i run the macro it does not seem to take out duplicates. In particular it duplicates the first entry in the list.

Currently getting frustrated

brian