Highlight Duplicates

[PinkHinky]

I have a list of over 3,000 patient names, addresses and phone numbers. What I need to do is have any duplicate names highlighted. The problem with this is there will be duplicates when it comes to the city, state and zip code and that's fine. The first cell containing the first and last name is B3, the next is B12 and it carries on every 9th cell with the last cell being B3045. Is there a way to identify duplicates only applying to these cells?

 

[brettdj]

I suggest you use a working column to extract very 9th data point, then look for dupes there

In row 1 of a new column put
=IF(MOD(ROW()-3,9)=0,B1,"")
and copy down to get the values for B3, B12, B21 etc with blanks for the other cells

Then use the standard dupe highlighting techniques (http://www.cpearson.com/excel/duplicates.aspx), or my dupe master addin http://www.experts-exchange.com/A_2123.html on the working column

Cheers

Dave

 

[PinkHinky]

That works, thank you!