| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Mode of Text....
wrote...
I need to pull the most commonly used word out of a data range. In essence if I have a list of names; Is there any way Excel can pull up the name that is repeated the most, and how many times it is repeated? Essentially a mode of text. I think Leo Heuser came up with this. =INDEX(rng,MODE(MATCH(rng,rng,0))) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MODE function for text entries | Excel Worksheet Functions | |||
| Mode function in excel using Text | Excel Discussion (Misc queries) | |||
| Mode for Text | Excel Worksheet Functions | |||
| Mode for Text | Excel Discussion (Misc queries) | |||
| Finding the mode of text | Excel Discussion (Misc queries) | |||
Hybrid Mode
