filtering repeat data

[jessica juarez]

i have a worksheet that contains a list of 46,000 phone numbers and I would
like to filter out the phone numbers that repeat more than 5 times but less
30 times. can someone please help.

 

[Debra Dalgleish]

You can use an Advanced Filter to extract the data. There are
instructions in Excel's Help, and here:

http://www.contextures.com/xladvfilter01.html

In the criteria area, leave the heading cell blank, and in the cell
below, enter a formula that counts the phone numbers. For example, with
phone numbers in column D:

=AND(COUNTIF($C$2:$C$46000,C2)>5,COUNTIF($C$2:$C$46000,C2)<30)

 

[Peo Sjoblom]

While doing this you might want to check unique records only so you don't
get a list of all the duplicates as well (unless you want that of course)
Also Debra had a typo, she meant column C


--
Regards,

Peo Sjoblom

Portland, Oregon