Hi,
There are a couple of ways todo this.
The easiest would be to put them into one column, sort them and do a simple =
(A1=A2)
If you can't, you can a Vlookup as follows (A1:A3 is the whole of your list
in column A:
VLOOKUP(B1,$A$1:$A$3,1,FALSE)
Note: Caution needs ot be taken when performing this type of work in Excel
as your list is only as good as the persons who performed the data entry.
eg: It won't identify Susen Douglas
HTH
Simon
HERNAN wrote:
I have 2 columns with text
A B
1 John Kim Susan Douglas
2 Susan Douglas Mary Barry
3 Martin Smith Mike Miguens
I want to locate and be able to sort the duplicates cells in column A (ie:
A2 ) so I can delete them later.
THANK YOU!!!!!!!!
--
--------------------
Simon - UK
Email at simon22mports [ a t ] hot mail [ d ot ]com
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200610/1