How do I find the highest of the most repeating values in a list ofnumbers ie. the max of the modes

[Kim]

Hi,

I have a list of numbers and I need to find the highest of the most
frequent occurrances.

For example:

List 1
1
3
3
4
4

Should return the value 4 because its the highest of the most frequent
occurrances of any number.

List 2
1
3
3
3
4
4

Should return 3 because it's the most frequent occurrance outright.

I've tried using the mode command but it returns the first of the most
frequent occurances but I want the highest of the most frequent
occurrances.

Any help would be greatly appreciated.

Thanks

Ana

 

[Hans Terkelsen]

Hi,

I have a list of numbers and I need to find the highest of the most
frequent occurrances.

For example:

List 1
1
3
3
4
4

Should return the value 4 because its the highest of the most frequent
occurrances of any number.

List 2
1
3
3
3
4
4

Should return 3 because it's the most frequent occurrance outright.

I've tried using the mode command but it returns the first of the most
frequent occurances but I want the highest of the most frequent
occurrances.

....

Hi Ana.

The mode command would do what you want
if the list was sorted highest first.

If sorting directly is not convenient, or not possible,
then the sorting could be done in the formula:
=MODE(LARGE(A2:A6,ROW(A2:A6)-1))
applying to List 1 (in A1 and down) of your example.

Hans T.