Excel Magic Trick 1118

MODE for Text Values, Extract Word That Occurs Most Frequently

DESCRIPTION

See how to Extract Word That Occurs Most Frequently:
(00:07) MODE calculation for text.
(00:57) COUNTIFS function for basic mode calculation
(01:38) INDEX, MODE and MATCH function (with function argument array operation) to extract the word that occurs most frequently when column of data contains text only.
(06:17) INDEX, MODE, MATCH, IF and ISTEXT function to extract the word that occurs most frequently when column of data contains text only.
(09:32) Formula to extract multiple text / word modes values that uses the functions, INDEX, SMALL, MODE.MULT, MATCH. Bill Szysz comes to the rescue again!!!!

WORKBOOKS