rjyusmc2005
New Member
- Joined
- Dec 3, 2020
- Messages
- 3
- Office Version
- 365
- 2019
- Platform
- Windows
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.
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.