Dupplicates
 

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

Dupplicates
 

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

Dupplicates
 

If this is your data:

A1: 1
A2: 1
A3: 2
A4: 3
A5: 3

What results do you expect?

--
Biff
Microsoft Excel MVP


"Eva" wrote in message
...
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

Dupplicates
 

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