array formula - count if - return unique/duplicated-CodePudding

Home > Software design > array formula - count if - return unique/duplicated

array formula - count if - return unique/duplicated

Time：09-28

I am trying to convert this pull-down formula into an array formula:

=IF(COUNTIF(A$1:A1,A1)=1,"Unique","Duplicated")

Any help?

CodePudding user response：

This should work for you:

=ArrayFormula(IF(A:A="",,IF(COUNTIFS(A:A,A:A,ROW(A:A),"<="&ROW(A:A))=1,"Unique","Duplicated")))