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 |