software

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.

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

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)gt;5,COUNTIF($C$2:$C$4 6000,C2)lt;30)

jessica juarez wrote:
gt; i have a worksheet that contains a list of 46,000 phone numbers and I would
gt; like to filter out the phone numbers that repeat more than 5 times but less
gt; 30 times. can someone please help.--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.htmlWhile 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

quot;Debra Dalgleishquot; gt; wrote in message
...
gt; You can use an Advanced Filter to extract the data. There are instructions
gt; in Excel's Help, and he
gt;
gt; www.contextures.com/xladvfilter01.html
gt;
gt; In the criteria area, leave the heading cell blank, and in the cell below,
gt; enter a formula that counts the phone numbers. For example, with phone
gt; numbers in column D:
gt;
gt; =AND(COUNTIF($C$2:$C$46000,C2)gt;5,COUNTIF($C$2:$C$4 6000,C2)lt;30)
gt;
gt; jessica juarez wrote:
gt;gt; i have a worksheet that contains a list of 46,000 phone numbers and I
gt;gt; would
gt;gt; like to filter out the phone numbers that repeat more than 5 times but
gt;gt; less
gt;gt; 30 times. can someone please help.
gt;
gt;
gt; --
gt; Debra Dalgleish
gt; Excel FAQ, Tips amp; Book List
gt; www.contextures.com/tiptech.html
gt;