COUNTIFS/LEN/UNIQUE

[rjyusmc2005]

I need a formula to count the number entries in a column with a length of 8 characters and exclude duplicates. Using O365.
Right now, I'm using "=countif(D:D,"????????")" to count just the rows with 8 characters. It works, but obviously does not omit duplicate entries.

 

[Fluff]

How about

=ROWS(UNIQUE(FILTER(D2:D100,LEN(D2:D100)=8)))

 

[rjyusmc2005]

How about

=ROWS(UNIQUE(FILTER(D2:D100,LEN(D2:D100)=8)))

Thank you. That works perfectly.

 

[Fluff]

You're welcome & thanks for the feedback.