Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
FIND AND SORT DUPLICATE TEXT
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 AND SORT DUPLICATE TEXT
http://www.j-walk.com/ss/excel/usertips/tip073.htm
hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "HERNAN" escreveu: 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!!!!!!!! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
FIND AND SORT DUPLICATE TEXT
Hi
In C3 =COUNTIF($B$1:$B$1000,A1)0 Copy down will return TRUE in column C on the row where duplicate data exists in column A -- Regards Roger Govier "HERNAN" wrote in message ... 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!!!!!!!! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
FIND AND SORT DUPLICATE TEXT
Thank you, but is not working since what I need is to find duplicate TEXTS
not numbers, so using this formula the result is allways FALSE. Any other idea please??? Thank you anyway. "Roger Govier" wrote: Hi In C3 =COUNTIF($B$1:$B$1000,A1)0 Copy down will return TRUE in column C on the row where duplicate data exists in column A -- Regards Roger Govier "HERNAN" wrote in message ... 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!!!!!!!! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
FIND AND SORT DUPLICATE TEXT
After I locate the duplicate how do I sort them?? I want to delete them. And
I have more than 4,000 names? Thank you!! Obrigado! "Marcelo" wrote: http://www.j-walk.com/ss/excel/usertips/tip073.htm hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "HERNAN" escreveu: 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!!!!!!!! |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
FIND AND SORT DUPLICATE TEXT
http://mcgimpsey.com/excel/conditional6.html
-- regards from Brazil Thanks in advance for your feedback. Marcelo "HERNAN" escreveu: After I locate the duplicate how do I sort them?? I want to delete them. And I have more than 4,000 names? Thank you!! Obrigado! "Marcelo" wrote: http://www.j-walk.com/ss/excel/usertips/tip073.htm hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "HERNAN" escreveu: 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!!!!!!!! |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
FIND AND SORT DUPLICATE TEXT
Thank you Marcelo, but I can't use the Conditional Formatting.
Maybe is because in each cell I have first and last name?? This is my example: A B 1 John Smith Mary Kim 2 Peter Johnson John Smith What should I do in "C" to identify the duplicates in A Please I really need help with this!!!! "Marcelo" wrote: http://mcgimpsey.com/excel/conditional6.html -- regards from Brazil Thanks in advance for your feedback. Marcelo "HERNAN" escreveu: After I locate the duplicate how do I sort them?? I want to delete them. And I have more than 4,000 names? Thank you!! Obrigado! "Marcelo" wrote: http://www.j-walk.com/ss/excel/usertips/tip073.htm hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "HERNAN" escreveu: 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!!!!!!!! |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
FIND AND SORT DUPLICATE TEXT
Did you try it?
It has nothing to do with whether the comparison is Text or Numeric. With your sample data, I return FALSE, TRUE, FALSE If you are not seeing that result, then maybe there are extra spaces in one of your columns of data. David McRitchie has some code for cleaning up data on his site http://www.mvps.org/dmcritchie/excel/join.htm#trimall -- Regards Roger Govier "HERNAN" wrote in message ... Thank you, but is not working since what I need is to find duplicate TEXTS not numbers, so using this formula the result is allways FALSE. Any other idea please??? Thank you anyway. "Roger Govier" wrote: Hi In C3 =COUNTIF($B$1:$B$1000,A1)0 Copy down will return TRUE in column C on the row where duplicate data exists in column A -- Regards Roger Govier "HERNAN" wrote in message ... 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!!!!!!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FIND DUPLICATE TEXT IN A COLUMN!!!!!!!!! | Excel Discussion (Misc queries) | |||
Sort text that is deliminated within a cell | Excel Discussion (Misc queries) | |||
How to sort text as numbers | Excel Discussion (Misc queries) | |||
VBA, excel - find, resize and sort | Excel Worksheet Functions | |||
How can I sort duplicate text data in excel? | Excel Discussion (Misc queries) |