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.

WORKBOOKS

Download “Excel Magic Trick 1101-1120” Excel-Magic-Trick-1101-1120.zip – Downloaded 4 times – 2 MB




Be the first to comment

Leave a Reply