Excel question

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

I was looking for an easy way to have Excel compare 2
documents or pages within a document, and have it identify
duplicate entries. I have spreadsheets with thousands of
entries and I need to identify which ones are duplicates.
I tried doing it with filters but did not have much luck
getting it right. If anyone knows of an easy way to do
this, short of writing macros, I would appreciate some
feedback.

Thanks Steve
 
Hi Steve!

Take a look at:

Chip Pearson:
http://www.cpearson.com/excel/duplicat.htm

A mine of useful formulas for handling duplicate / unique problems.



--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top