You can use multiple columns and get a list of unique combinations of those
columns.

You may want to post what failed when you tried it.

wrote:

I've seen many posts using one column and how to use the advanced
filter but I don't think you can use them with two columns of info.

My s/s (often +1000 records) has col C LastName & col D FirstName with
other supporting details e.g. address, email of stakeholders. Many
times there are the same surnames but with the same or different
firstnames.

Can someone please help with some code to highlight the Last & First
names of rows that are duplicated (have the same last & first names).
I do not want them hidden or deleted.

Thanks so much.

Peta

--

Dave Peterson