Hi

G2: =IF(COUNTIF($A$3:$A$55,F3),2,1)

Adjust the ranges and copy down as required.


rylo