One for all you Excel gurus: I have to dedupe an Excel 97 worksheet, based on the contents of a single column. I have about 10,000 rows of data, of which about 1,000 have two or three duplicate entries in the column. I'm going blind trying to find all the dupes.

Do any of you know a way to hide the single entry data, so I can focus on fixing the dupes? This would make my life much easier...

thanks,

-jl