How do I identify duplicate IDs and assign values

Helal

New member
Joined
Dec 3, 2011
Messages
14
Reaction score
0
Points
0
I need to identify duplicate records based on unique ID number and assign a value 1 to the first occurance and 0 to the rest. Here is an example:
ID
Assign
01
1
01
0
01
0
02
1
02
0
02
0
02
0

Thank you,

Helal
 
=IF(COUNTIF($A$2:A2;A2)=1;COUNTIF($A$2:A2;A2);0)
paste the formula to the first row ( under the assign column) and drop it down
good luck
 
Thank you...but I get error on so I replaced ; with , and it worked.
 
Back
Top