Excel Magic Trick 1193


Count Distinct Words As They Are Entered In Column: Formula or Excel Table?

DESCRIPTION

See how calculate a running count for each unique (distinct) text items entered in column using two methods:
(00:10) Problem setup
(00:52) COUNTIFS with an Expandable Range, with the IF and ISBLANK functions
(02:56) Excel Table Feature, Table Formula Nomenclature (Structured References), COUNTIFS function and the INDEX function to create an Expandable Range

WORKBOOKS