If column A contains your data, and is sorted so that duplicates are
displayed together, then in B2 put this formula and copy down...........
=IF(A2=A1,"Duplicate","")
Vaya con Dios,
Chuck, CABGx3
"julz" wrote in message
...
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","")
|