User-15895
Reputation: 15
array formula - count if - return unique/duplicated
I am trying to convert this pull-down formula into an array formula:
=IF(COUNTIF(A$1:A1,A1)=1,"Unique","Duplicated")
Any help?
Upvotes: 0
Views: 87
Answers (1)
Erik Tyler
Reputation: 9345
This should work for you:
=ArrayFormula(IF(A:A="",,IF(COUNTIFS(A:A,A:A,ROW(A:A),"<="&ROW(A:A))=1,"Unique","Duplicated")))
Upvotes: 1
Related Questions
- Excel Dynamic Array Running Count of Duplicates
- G Sheet - Array Formula - count occurrences value in a list?
- Count Unique values on an array based on multile criteria google sheets
- Counting first occurrence in Google Sheets with additional condition
- Google Sheets Formula to Count Occurrences of Unique Values in Columns
- Needing to count record if it shows up on 2nd sheet, but only want to count once
- Detecting Duplicates in a Google Sheet with ARRAYFORMULA
- How to Count Duplicate values based on other cell values in google sheet
- Count IF with Unique in sheets
- Count unique values with criteria