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

  • Thread starter Thread starter Kim
  • Start date Start date
K

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
 
Kim said:
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.
Click to expand...
....

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.
 
Back
Top