How to find the duplicate text from a column or from a row?
 

In a helper column

=IF(COUNTIF($A$1:A1,A1)1,"Dup","")

and copy down

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Yohan" wrote in message
...