#1   Report Post  
Old July 15th 11, 03:22 PM
Junior Member
 
First recorded activity by ExcelBanter: Jan 2011
Posts: 6
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Establishing most common word in an Excel column Brymor Excel Worksheet Functions 10 February 3rd 10 04:38 PM
Determine if 2 cells share a common word paul c Excel Worksheet Functions 2 January 14th 10 03:52 AM
Combining two ranges based on common a common value ahmed[_3_] Excel Discussion (Misc queries) 5 April 18th 09 05:04 PM
inserting rows at common word in a sheet Ankur Excel Discussion (Misc queries) 0 August 10th 05 11:18 AM
what three features in word,excel and powerpoint have n common? collegemom2005 New Users to Excel 1 June 11th 05 09:54 PM


All times are GMT +1. The time now is 11:10 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017