View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Joe Lewis[_2_] Joe Lewis[_2_] is offline
external usenet poster
 
Posts: 9
Default Returning the most duplicated item

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.