Need help to filter

[bgbs]

I have this formula someone helped me compose last time on this forum, but I cant figure out how to filter data using this formula.

=COUNTIF($A$1:A1,A1)=1


Basically this formula finds email duplicates and displays FALSE if they are a duplicate. I want to get rid of those duplicates quickly if I knew how tosort them and delete all at once instead of finding each duplicate and deleteing one by one.

I dont know what filtering does exactly. What I did to filter is select the column to which I applied the formula and click on filter and selected to filter on FALSE, but what it does is make every email false. Then I tried TRUE, and it makes every email true. So either I dont know how filter works, or it really doesnt work.

please help

[sglife]

You can use "Advanced Filter"

[bgbs]

Thats complicated. It basically fails when filtering a formula. The only way I think it can be fixed if there is a way to discard the formula after it processed but have it keep the results (true or false) shown as words, that way you can just sort and thats it. But I dont know if it is possible and how to do that.