Excel Magic Trick 1118: MODE for Text Values, Extract Word That Occurs Most Frequently

See how to Extract Word That Occurs Most Frequently:
1. (00:07 min) MODE calculation for text.
2. (00:57 min) COUNTIFS function for basic mode calculation
3. (01:38 min) 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.
4. (06:17 min) INDEX, MODE, MATCH, IF and ISTEXT function to extract the word that occurs most frequently when column of data contains text only.
5. (09:32 min) Formula to extract multiple text / word modes values that uses the functions, INDEX, SMALL, MODE.MULT, MATCH.

Bill Szysz comes to the rescue again!!!!
Excel Magic Trick 592: Extract Word That Occurs Most Frequently - MODE for Word - Data Array Formula

[excelisfun]

Excel Magic Trick 1118: MODE for Text Values, Extract Word That Occurs Most Frequently 

See how to Extract Word That Occurs Most Frequently:
1. (00:07 min) MODE calculation for text.
2. (00:57 min) COUNTIFS function for basic mode calculation
3. (01:38 min) 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.
4. (06:17 min) INDEX, MODE, MATCH, IF and ISTEXT function to extract the word that occurs most frequently when column of data contains text only.
5. (09:32 min) Formula to extract multiple text / word modes values that uses the functions, INDEX, SMALL, MODE.MULT, MATCH.

Bill Szysz comes to the rescue again!!!!

[pmsocho]

This is awesome. I talked to Bill about that yesterday and booom - we got the video from you! Thanks ExcelIsFun and Bill Szysz!

[myrabbitispink]

i like how far you break it down. you are definitely knowledgable on this subject

[davidbartonjr]

Crazy! I Love it! Don't really need it, but I honor and salute guys like you! Thanks!

[brettconway]

Absolutely brilliant, just what I needed, probably one of the best Excel Video's I have watched!! Thanks for such a clear explanation ;o)

[jacquesjacques]

thanks, this video really saved me <3

[stephenmorgan]

This is great thanks. One question, is it possible to work this formula over multiple columns. I have a similar sheet but my 'Survey Data' are inputted over 3 columns. For various reasons I cant collate the 3 columns into one.

[jpguitar]

Can i use the mode for text with sentences?

[duanedonaldson]

Only guessing but Bills lasy name looks like a "Call SIgn", sounds like German for if you know a little German, IMHO. Thank you for all the awesome lessons.

[rajanrajan]

Hi. How do we list the second most frequently used text value instead of the first?

[friedchickenbucket]

Hi, would you know how to apply this to a situation where I need the most occuring text within a specified date range? If Survey Data also had a date column, I want to know what was the most common occuring word in the year 2016. If you can help, that will be great.

Thanks

[myrabbitispink]

this works great for when each cell only contains one word/ one reoccuring string of words and nothing else. however when you have different full sentences in each of your cells and try to filter out the most frequently used word across those it doesnt work any longer. any suggestions?

[sndp]

Hi mike you are awesome, hey i have a question that is that any array formula which can return random selected values from a column  without using helper column.

[leonidkoyfman]

If in case of the mixed value types list we desided to treat all values as a text, the formula will be
=INDEX($C$19:$C$25&"", MODE(MATCH($C$19:$C$25&"", $C$19:$C$25&"", 0)))
and it doesn't need SCE.
We also might need to show something more descriptive than just #N/A when all values are unique and there is no mode.

[bobwiebe]

This is awesome! I cam up with =INDEX($A$11:$A$640, MODE.MULT(IF(ISTEXT($A$11:$A$640), MATCH($A$11:$A$640, $A$11:$A$640, 0)))) and it works great. But I am using it on a filtered list, how can I add the subtotal function or a function like it where it will change the list when filtering?

[osmondmolina]

does this require a specific version of excel? Not working on my file now.

[asandaswaartbooi]

I am using excel 2013, when I click the left arrow button, the position is not switched to the left direction.

[Amatureithelpstation]

Hello. If I submit a video question would you possibly have time to answer it?

[jwb]

My range is all text and I altered this formula to fit my range butttt it kicks back "0" every time. No idea why.

[NotAnYoutubeChannel]

I loved this video so much I could marry you