Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
highlight duplicate rows | Excel Discussion (Misc queries) | |||
How to Highlight Two Rows With Two Columns of Duplicate Values | Excel Worksheet Functions | |||
Highlight/remove duplicate rows | Excel Programming | |||
comparing 2 sheets and list unique and duplicate rows | Excel Programming | |||
Comparing 2 rows for duplicate data | Excel Programming |