Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
filtering repeat data
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
filtering repeat data
You can use an Advanced Filter to extract the data. There are
instructions in Excel's Help, and he 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$4 6000,C2)<30) jessica juarez wrote: 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 Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
filtering repeat data
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 "Debra Dalgleish" wrote in message ... You can use an Advanced Filter to extract the data. There are instructions in Excel's Help, and he 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$4 6000,C2)<30) jessica juarez wrote: 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 Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Find repeat data in a worksheet | Excel Discussion (Misc queries) | |||
filtering row data | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Repeat Paste of Data | Excel Worksheet Functions |