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