how to check for recurrence of same names in column 1 and column
 

I have a spreadsheet with names in one column and a list of names in another
column copied from another spreadsheet. I would like to check if any of the
names are repeated in column 2 please if possible?

how to check for recurrence of same names in column 1 and column
 

See

http://cpearson.com/excel/duplicat.htm

In article ,
JillyB wrote:

I have a spreadsheet with names in one column and a list of names in another
column copied from another spreadsheet. I would like to check if any of the
names are repeated in column 2 please if possible?