I have a database with a number of address listings. I know that there are
duplicate accounts in my list. Right now the only way that I know how to do
it is to sort by address and then look for duplicates. Is there a formula
that I can use. I am familiar with Vlookup, etc, but can't find one that
works.
Thanks,
A.Pon

Check out

http://cpearson.com/excel/duplicat.htm


In article <IxZwd.215391$V41.7862@attbi_s52>,
"AAP" <(E-Mail Removed)> wrote:

> I have a database with a number of address listings. I know that there are
> duplicate accounts in my list. Right now the only way that I know how to do
> it is to sort by address and then look for duplicates. Is there a formula
> that I can use. I am familiar with Vlookup, etc, but can't find one that
> works.
> Thanks,
> A.Pon