Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
FIND DUPLICATE TEXT IN A COLUMN!!!!!!!!!
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!!!!!!!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
FIND DUPLICATE TEXT IN A COLUMN!!!!!!!!!
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro | Excel Discussion (Misc queries) | |||
Searching for Duplicate Text in a column | Excel Worksheet Functions | |||
FIND A TEXT IN A WORKSHEET NOT IN A COLUMN OR ROW BY FORMULA | Excel Discussion (Misc queries) | |||
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
How can you find duplicate numbers in a column? | Excel Worksheet Functions |