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

J

JillyB

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?
 
Top