I would sort the collumn ascending, assuming it to be A, then in helper
column B6 put this and copy down.....

=IF(A6=A1,"Delete Me","")

Copy PasteSpecial Values on column B
Then sort on column B and delete the rows indicated

Vaya con Dios,
Chuck, CABGx3



"jessica juarez" wrote in message
...
I have a huge list of telephone numbers and I have to filter out the ones
that appear more than 5 times, any ideas