software

I have combined several mail list into one on excel workshett and have quite
a few dupicates. How can I find and delete duplicates?

I wasn't able to find anything in excel that would accomplish this. I had
the same problem and bought DIGDB and excel add in. I couldn't live
without, it is a wonderful tool to use in exel.

quot;mrsthicknessquot; wrote:

gt; I have combined several mail list into one on excel workshett and have quite
gt; a few dupicates. How can I find and delete duplicates?

I use the following formula in a list to find duplicates. It doesn't auto
delete but helps you detect easily. Of course you need to ensure your list
is sorted alphabetically and then the formula looks above and below a line
for duplicate:

=IF(OR(A5=A6,A5=A4),quot;dupquot;,0)

quot;DIANE Kquot; wrote:

gt; I wasn't able to find anything in excel that would accomplish this. I had
gt; the same problem and bought DIGDB and excel add in. I couldn't live
gt; without, it is a wonderful tool to use in exel.
gt;
gt; quot;mrsthicknessquot; wrote:
gt;
gt; gt; I have combined several mail list into one on excel workshett and have quite
gt; gt; a few dupicates. How can I find and delete duplicates?