Maximum repeated value

[ratanbhushan2910]

In my data call contains value as:

2 2 3 3 2 3 1 2 3 4 4

and in the last cell I want the maximum times repeated number, as there is 3 repeated for maximum number.

All the values written above are in the consecutive cells(Row)

 

[XOR LX]

Hi.

What if more than one number match that criterion?

Regards

 

[VorLag]

You can use either MODE.SINGL(array) or MODE.MULT(array) to pull out the value that repeats the most.

 

[ratanbhushan2910]

Lets take an example as given below

1,2,3,1,4,1 = 1

There is no criteria to select the maximum repeated but only numbers

2,1,2,1,5 = either 1 or 2