Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Mode of Text....
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Mode of Text....
Assuming your text values are in A1:A10, insert a new column and enter
=COUNTIF($A$1:$A$10,A1) in cell B1 and fill down to B10. Then use the following formula to return the value in column A that occurs the most frequently. In case of a tie (2 different strings occur the same number of time), the first (lowest row number) item will be returned. =INDEX(A1:A10,MATCH(MAX(B1:B10),B1:B10,0),0) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email on the web site) wrote in message oups.com... 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. |
#3
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) |