Posted to microsoft.public.excel.misc

jessica juarez

Posts: n/a

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel Macro to Copy & Paste	[email protected]	Excel Worksheet Functions	0	December 1st 05 01:56 PM
Find repeat data in a worksheet	J1	Excel Discussion (Misc queries)	1	November 2nd 05 11:08 PM
filtering row data	Gary''s Student	Excel Worksheet Functions	3	October 26th 05 07:03 PM
Sort pages?	David	Excel Discussion (Misc queries)	15	May 13th 05 11:33 PM
Repeat Paste of Data	SiouxieQ	Excel Worksheet Functions	0	November 19th 04 07:27 PM

All times are GMT +1. The time now is 07:00 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us