FINDING DUPLICATE TEXT IN 2 COLUMNS!!!!!

H

HERNAN

I have 2 columns with text

A B
1 John Smith Lucas Douglas
2 Lucas Douglas Mary Moe
3 Mike Kim Susan Berry

I want to locate the cells with duplicate names on the 1st column (ie: A2)
so then I can SORT the ones that are duplicate and delete them.
Thank you so much for any help!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

FIND DUPLICATE TEXT IN A COLUMN!!!!!!!!! 1
FIND AND SORT DUPLICATE TEXT 7
Conditional Format Formula for finding duplicates in a row 1
Formating bolded text exclusively. 0
concatenate 2 columns (A2+B2) and compare for duplicates 3
Search cell value in same column 3
check for duplicates 10
Finding duplicates in Multiple Columns 16

Top