good evening,

i'm needing to tag duplicate entries in a single column. the entries were
downloaded from access. i'm using the following formula, but keep returning
#NAME?. please advise.

=IF(COUNTIF(Range1,A1)1,"Duplicate","")