Most frequent data in a list

karenO

New Member
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

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type
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

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

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

=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.

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

Replies
4
Views
318
Replies
3
Views
457
Replies
6
Views
240
Replies
22
Views
830
Replies
3
Views
338

1,221,423
Messages
6,159,822
Members
451,591
Latest member
j0eyjedi

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back