• Share

Discuss in my forum

Excel MODE.SNGL Function

Find the Most Common Number in a List of Data

Excel MODE.SNGL Function

In Excel 2010, the MODE.SNGL function, was introduced to replace the MODE function found in previous versions of Excel.

Despite its new name, MODE.SNGL still does the same job which is to show you the most frequently occurring value in a list of numbers.

The syntax for the MODE.SNGL function is:

= MODE.SNGL ( number1, number2, ... number255 )

Note: Up to 255 numbers can be entered into the function.

Excel's MODE.SNGL Function Example

1. Enter the following data into cells D1 to D6: 98, 135, 147, 135, 98, 135.

2. Click on cell E1 - the location where the results will be displayed.

3. Click on the Formulas tab.

4. Choose More Functions > Statistical from the ribbon to open the function drop down list.

5. Click on MODE.SNGL in the list to bring up the function's dialog box.

6. Drag select cells D1 to D6 in the spreadsheet to enter the range into the dialog box.

7. Click OK.

8. The answer 135 should appear in cell E1 since this number appears the most (three times) in the list of data.

9. When you click on cell E1 the complete function = MODE.SNGL ( D1 : D6 ) appears in the formula bar above the worksheet.

Note: If the selected data range contains no duplicate data, the MODE.SNGL function will return a #N/A error.

Ted French