filter my frequency

I have a huge list of telephone numbers and I have to filter out the ones
that appear more than 5 times, any ideas

If your data is in column A, you can put this in column B:

=countif(a:a,a1)
and drag down

Then apply data|filter|autofilter to column B.
Custom filter
greater than 5

And delete the visible rows.

This will delete all the numbers that appear more than 5 times. If you only
wanted to keep up to the first 5 instances, you could use a formula like:

=countif($a$1:a1,a1)
and drag down.

And still filter to show the counts greater than 5.

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

--

Dave Peterson

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" <jessicajuarez@discussions.microsoft.com> wrote in message
news:CF49C9FD-3B49-4548-9617-3466451EAB89@microsoft.com...
> I have a huge list of telephone numbers and I have to filter out the ones
> that appear more than 5 times, any ideas
>