Help with Dulpicate finding program....

[Guest]

HI

I have found one program Excel Duplication Manager Add
that I purchased a while ago.
The problem i am having is when I use the program, and it highlights my
duplicates, it is SOOOOOOOOOOOOOOOOOOOOOOO SLOWWWWWWWWWWWWWWWWWW , as in I
can't error down FAST when I do not use the program.

Is their another program out their that is better, that I can use???
Please help!!!

Thanks

 

[David McRitchie]

Hi Patti,
Here are some places to look for hints in using
Worksheet Formulas to identify duplicates. You can
also use Conditional Formatting to identify duplicates
as they use [almost] the same worksheet formulas
as you would use in a cell. The difference is that
the purpose of a CF formula is to produce True or False.

Chip Pearson's topic index look for "dupli"
http://www.cpearson.com/excel/topic.htm

Filtering is a way to retain rows, but not show them

Debra Dalgleish's site index
http://www.contextures.com/tiptech.html

my page on Duplicates
http://www.mvps.org/dmcritchie/excel/duplicates.htm

If you need help installing a macro you find, see my
http://www.mvps.org/dmcritchie/excel/getstarted.htm#havemacro

This page looks like it might work for you:
The Duplicate Master. A free add-in for Microsoft Excel
http://members.iinet.net.au/~brettdj/