|
Featured Tutorial
Featured Macro
Excel Magic Trick 592: Extract Word That Occurs Most Frequently - MODE for Word - Data Array Formula
See how to extract word that occurs most frequently from a column of survey results that contain customer preferences for a product using the INDEX, MATCH, MAX and COUNTIF functions. This is a way to get the MODE for data that is made up of words (not numbers). This is an array formula and requires Ctrl + Shift + Enter. Statistical survey results for new product data.