dslreports logo
 
    All Forums Hot Topics Gallery
spc
uniqs
8

aurgathor
join:2002-12-01
Lynnwood, WA

aurgathor to CylonRed

Member

to CylonRed

Re: [Excel] finding duplicates

It's Excel 2000.
LLigetfa
join:2006-05-15
Fort Frances, ON

LLigetfa

Member

Can you import the data into MS Access? That's how I would do it.

CylonRed
MVM
join:2000-07-06
Bloom County
·Metronet

1 edit

CylonRed to aurgathor

MVM

to aurgathor
You can try this:
»uk.answers.yahoo.com/que ··· 3AAb3x5X
quote:
Let's say you want to highlight the duplicates yellow.
1. Highlight the entire column yellow.
2. Data-Filter-Advanced Filter
- pick Filter the list, in place
- check Unique records only
(this will hide the duplicates)
3. Select the visible cells and turn off the highlighting
4. Data-Filter-Show All

All the records should now be displayed, with only the duplicates highlighted. I believe the first instance of a duplicate will not be highlighted, but the others will be.

LLigetfa
join:2006-05-15
Fort Frances, ON

LLigetfa

Member

I don't have 2000 to test with but that works for me in Excel 2003.