Excel Forum

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.

Got a Question? Ask it Here in the Forum.