Return First Duplicated value as 1 and others as zero

[noman050]

Hi Everyone,

I have a data set where i have duplicate entries. I want to return first duplicate entry as Digit 1 and other duplicated entry of the same name as zero. For example

Apple 1

Apple 0

Kiwi 1

Kiwi 0

Kiwi 0

Apple 1

As you can see in the example the other duplicate entries of Apple and kiwi are tagged as Zero.

Thanks in advance for your Help

 

[noman050]

Sorry Guys the last Apple Value is Zero.

This is my first time on thread so cant find the edit option

 

[ANAND KUMAR]

Hi,

Welcome to Board......

Assuming Data starts from A2 Then enter this formula in B2 and copy down,

=IF(COUNTIF($A$2:$A2,$A2)=1,1,0)

 

[noman050]

Hi,

Welcome to Board......

Assuming Data starts from A2 Then enter this formula in B2 and copy down,

=IF(COUNTIF($A$2:A2,A2)=1,1,0)

Yup got it done