Use `=COUNTIF($A$1:$A$100,A1)>1` to return TRUE for duplicate values
Use `=IF(COUNTIF($A$1:$A$100,A1)>1,”Duplicate”,”Unique”)` to label duplicates
Use `=COUNTIF($A$1:A1,A1)>1` to mark only repeated occurrences after the first one
Use `=IF(COUNTIF($A$1:A1,A1)>1,”Duplicate”,””)` to show duplicates only once they repeat
Use `=SUMPRODUCT(–($A$1:$A$100=A1))>1` to identify duplicates
Use `=IF(SUMPRODUCT(–($A$1:$A$100=A1))>1,”Duplicate”,”Unique”)` to classify values
Use `=COUNTIFS($A$1:$A$100,A1)>1` for duplicate checks across a range
Use `=IF(COUNTIFS($A$1:$A$100,A1)>1,”Duplicate”,”Unique”)` to display duplicate status
Use `=IF(COUNTIF($A$1:$A$100,A1)=1,”Unique”,”Duplicate”)` to reverse the result logic
Use conditional formatting with `=COUNTIF($A$1:$A$100,A1)>1` to highlight duplicate cells