VLOOKUP - I think...

[Eán]

I have four coloums of data surname, date of birth, surname, date of birth
and I need to highlight / pick out the duplicates?
What's the easiest way to do it please?

Many thanks,

 

[Glenn]

I have four coloums of data surname, date of birth, surname, date of birth
and I need to highlight / pick out the duplicates?
What's the easiest way to do it please?

Many thanks,

Duplicate surnames, duplicate date of births, or both? Duplicate in the same
column, the other column, or both?

 

[Herbert Seidenberg]

Excel 2007
Highlight, pick out duplicate columns.
Three ways:
http://www.mediafire.com/file/rxnymmemwmx/03_20_09.xlsx