|
Featured Tutorial
Featured Macro
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.