Excel Forum

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.