Hi
one way:
- use a helper column. e.g. in d1:
=A1 & "^" & B1 & "^" & C1
and uye this helper column
--
Regards
Frank Kabel
Frankfurt, Germany
rinks wrote:
How would I apply this to identify duplicates within data that spans
multiple columns?
Example:
Last Name First Name Address
Smith John 123 Main St
Adams Bill 456 Park St
Smith John 123 Park St
"Dave R." wrote:
You can use a formula like this
=COUNTIF(A$1:A$1000,A1)
next to all your records. Then you can sort them by that column and
delete anything with a "2" next to it.
More info here;
http://www.cpearson.com/excel/duplicat.htm
"rinks" <rinks @discussions.microsoft.com wrote in message
...
I am merging two mailing lists (lists A & B). Some of the names
from list A are also in List B. When I merge the two, I want to
delete any records that are duplicated. I want to delete the
original record and the duplicate, so an advanced filter selecting
"Unique records only" will not work. What do I do? Is there an "IF"
statement that I can run against the merged list that will identify
and deleted any record that is duplicated?