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.