Excel Forum
Similar Content
Count The Number of Words in a Cell or Range of Cells in Excel - UDF
Macro: Count words in cells with this user defined function (UDF). This UDF allows you to count t...
Count The Number of Words in a Cell or Range of Cells in Excel - With User-Specified Delimiter / Separator - UDF
Macro: UDF to count the number of words in a cell or range with a user-specified delimiter. ...
Count the Number of Unique Values in a List in Excel
Tutorial: Use a formula to count the number of unique values that are contained within a list in Exc...



Excel Magic Trick 293: Dynamic Count Unique Words In Column


See two cell formulas and a named formula that will dynamically count unique words in a column. As you add new records, the count will automatically update. See the functions: MAX, ROW, OFFSET, SUMPRODUCT, ISTEXT, COUNTIF and array formulas.





Got a Question? Ask it Here in the Forum.