In P1 enter =COUNTIF($O$1:$O$45000,O1)1

Double-click to copy down.

DataFilterAutofilter for TRUE

Select column O and F5SpecialVisible cells only

Then EditDeleteEntire Row


Gord Dibben MS Excel MVP

On Tue, 22 Jul 2008 12:50:00 -0700, Mongo the Magnificent <Mongo the
wrote:

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?