Posted to microsoft.public.excel.worksheet.functions

Mongo the Magnificent Mongo the Magnificent is offline

external usenet poster

Posts: 1

Remove Rows That Are NOT Duplicates

I have a very large spreadsheet (45,000+ rows). I want to identify the
duplicate entries based on data that is in column O. I know how to do this
using conditional formatting and all works well. Thing is, I want to
ELIMINATE or HIDE the rows that are NOT duplicated. This is the exact
opposite of all the instructions I can find. They want to get rid of the
duplicates. I want to keep the dupes and and get rid of the single entries.

Can anyone help me?

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
Remove Duplicates	dk	New Users to Excel	15	March 28th 08 07:41 AM
How to remove duplicates?	Lakewoodsale	Excel Discussion (Misc queries)	2	January 25th 08 10:31 PM
Merge and remove duplicates?	Shanel	Excel Worksheet Functions	1	January 23rd 08 10:13 PM
how to remove duplicates ONLY within the same category	Landa	Excel Discussion (Misc queries)	5	April 26th 07 10:04 AM
Remove duplicates	Tuttamay77	Excel Discussion (Misc queries)	4	May 12th 06 10:56 PM

All times are GMT +1. The time now is 11:51 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us