Hey Guys & Gals,
I have compiled a list of address with:
A1 Name B1 Address C1 City D1 State E1 Zip
I have some duplicates, is their an easy way find and delete them?
Thanks for the help.
Myrkk
Hey Guys & Gals,
I have compiled a list of address with:
A1 Name B1 Address C1 City D1 State E1 Zip
I have some duplicates, is their an easy way find and delete them?
Thanks for the help.
Myrkk
Last edited by Myrkk; 04-01-2011 at 12:08 PM.
in f1 put =a1&b1&c1&d1 in g1 put =countif($f$1:f1,f1)>1 drag both down then filter g1 on TRUE
delete all
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Also - besides making a concatenated index like Martin suggests above, the newer versions of Excel (2007 and 2010) have this (Delete Duplicates) as a normal feature.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
I apologize, you lost me. F1 =a1&b1&c1&d1 --- G1 =countif($f$1:f1,f1)>
I dragged both down. How do I filter G1 on true?
Thanks for the help
use autofilter data/filter autofilter
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks