in data across multiple columns?

No this version one column

But you can use a helper column that will merge
your last and first name and use the duplicate option on that column

=A1&" " & B1



--
Regards Ron de Bruin
http://www.rondebruin.nl


"rinks" wrote in message ...
That is a great tool, but can it be used when I am searching for duplicates
in data across multiple columns?
Example:
Last Name First Name Address
Smith John 123 Main Street


"Ron de Bruin" wrote:

Hi

My Add-in have a duplicate option that you can use
http://www.rondebruin.nl/easyfilter.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl


"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?