Mode Function

Question:     We commissioned a research into the buying habits of our clients. How can we find the most frequently ordered quantity of our product?

Answer:        By using the Mode function

Why:            Returns the most frequently occurring, or repetitive, value in an array or range of data.



Number1, number2, …   are 1 to 255 arguments for which you want to calculate the mode. You can also use a single array or a reference to an array instead of arguments separated by commas.


Arguments can either be numbers or names, arrays, or references that contain numbers.

If an array or reference argument contains text, logical values, or empty cells, those values are ignored.

Applies To:   Excel 2003, 2007 and 2010

  1. For this example the following screen shot will be used.

2.  To find the mode ;

3.  Select B12 and type =Mode(B3:B11)

4.  The answer will be 10

5.  Meaning the quantity of product A that most clients ordered is 10



If you have any suggestions for an Excel Tips & Tricks topic, or you would like help with a particular function, please email [email protected] and yours could be the next Tip of the Week.

Alchemex provides examples of MS Excel procedures for illustration only, without warranty expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The MS Excel procedures on this web site are provided “as is” cannot be guaranteed that they can be used in all situations