Works. Thank you very much!
Eva
--
Greatly appreciated


"Jacob Skaria" wrote:

You said you have data in ColA.....In ColB cell B1 try the below formula and
copy down as required.

=IF(COUNTIF(A:A,A1)1,"Duplicate","")

If this post helps click Yes
---------------
Jacob Skaria


"Eva" wrote:

Hi
I have in column A the data. In column B I would like to set the formula
that check if there are dupplicates. I tried this =COUNTIF(B$1:B2,B2)=2 but
it doesn't show me the first item that has dupplicates. Do you know how to
solve this problem?
Thanks
--
Greatly appreciated
Eva