| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Most Common Name In Column Using Cell formular
Hi folks.....
I have a list of names that may have duplicates. I need to write a formular in a cell that will return the most commonl used name. ie. Jack John Fred Bill Jack John Steve Jack As in the column above the most commonly used name is "Jack" Is there a formular or combination of formular that I can enter into cell or cells that will give me the same result? Thanks for your help. Celtic_Avenger  :confused-- Message posted from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| FInd common data in one column then add number in adjacent column | Excel Worksheet Functions | |||
| Formular to count occurence of a number or letter in a column | Excel Worksheet Functions | |||
| formular for finding data and inserting value in seperate column | Excel Discussion (Misc queries) | |||
| Formular to read the last entry in a column | Excel Discussion (Misc queries) | |||
| find common text in cell in column in sheet then return total amou | Excel Worksheet Functions | |||
![Celtic_Avenger[_29_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
