FIND DUPLICATE TEXT IN A COLUMN!!!!!!!!!

[Guest]

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!!!!!!!!

 

[smw226 via OfficeKB.com]

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

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.aspx/ms-excel/200610/1