If you dont need to see the ties then you could simply type MODE A2A200 in C4. Also if you want to calculate the mean quickly you can just select the range. For example the mode of.
Calculate mean mode and median to find and compare center values for data sets.
Now take the sum of the numbers 9 and divide it by the amount of numbers 3. Median which is the middle number of a group of numbers. How to Calculate the Median in Excel using Formula. Mode which is the most frequently occurring number in a group of numbers.