In . com, Carim
spake thusly:

=IF(MATCH(A1,$A$1:$H$1,0)=COLUMN(A1),"Unique","Not Unique")

should do the job ...

Don't you have the logic reversed there? Or am I confused?
Would have thought you meant:

=IF(MATCH(A1,$A$1:$H$1,0)=COLUMN(A1),"Not Unique","Unique")

--
dman