Most frequent data in a list

[karenO]

I have a list of phone numbers and I need a function to show me which one appears most often in the list? Is there a neat little function in the list

Any help appreciated

Karen

 

[gnaga]

Have you tried CountIF Function to count the rpeated value in a range of data?

=CountIf(A:A,123) will return the number of apperance of 123 in the column A.

GNaga

 

[karenO]

I could use that these are just numbers called and I don't want to know if a specific number has been called I want to know which one has been called the most. Hope that clarifies it

Karen

 

[karenO]

I could use that these are just numbers called and I don't want to know if a specific number has been called I want to know which one has been called the most. Hope that clarifies it

Karen

 

[Aladin Akyurek]

=MODE(Range)

if Range is of numeric type.

=INDEX(Range,MATCH(MAX(SETV(COUNTIF(Range,Range))),GETV(),0))

which you need to array-enter, that is, to hit control+shift+enter at the same time (not just enter). Note that this formula holds for a range that is either of numeric type or type text.

Postscript. SETV and GETV are part of the morefunc.xll add-in, downloadable from:

http://longre.free.fr/english/index.html
This message was edited by aladin akyurek on 2002-09-24 08:33