| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Most common word
I am trying to write a formula which will return the most common word (1) in a column for a name in a different column. Example below
A B Rich Home Mike Away Dave Away Mike Away Dave Home Rich Home Mike Home Rich Away Dave Home I would like the formula to return the following Rich Home Mike Away Dave Home |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Establishing most common word in an Excel column | Excel Worksheet Functions | |||
| Determine if 2 cells share a common word | Excel Worksheet Functions | |||
| Combining two ranges based on common a common value | Excel Discussion (Misc queries) | |||
| inserting rows at common word in a sheet | Excel Discussion (Misc queries) | |||
| what three features in word,excel and powerpoint have n common? | New Users to Excel | |||
Linear Mode
