Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Let's say I have a column with a bunch of names in it, and I want a function
that will return the name that shows up the most often (the mode I guess). How do I do that? I know how to do it if the items are numerical data, but how do I do it with text? For example, suppose this is a column: Smith Johnson Smith Roberts Johnson Mulligan Roberts Smith Williams Williams Smith I want a function that will return "Smith" as the name that appears the most often. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
GET.CHART.ITEM returning strange results | Charts and Charting in Excel | |||
Item numbers result in item description in next field in Excel | Excel Worksheet Functions | |||
Duplicated cells | Excel Worksheet Functions | |||
Returning the last item in column | New Users to Excel | |||
Selecting an Item from a List and getting a different item to pop. | Excel Worksheet Functions |