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