Excel Forum
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




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.