The MODE function in Excel makes it easy to find the value that occurs most often in a set of selected data. Learn how to use the MODE function, along with its function substitutions, MODE.SNGL and MODE.MULT.
How to calculate average in Excel
Beginning with Excel 2010, Microsoft introduced two alternatives to the all-purpose MODE function. Although MODE is still available in Excel for backward compatibility, you should consider using these new functions because MODE may not be available in future versions of Excel.
These new MODE features are:
Here are examples of the different ways the MODE function is used:
