The MODE.SNGL function takes multiple arguments in the form number1, number2, number3, etc. Arguments can be a hardcoded constant, a cell reference, or a range, in any combination. MODE.SNGL ignores empty cells, text values, and the logical values TRUE and FALSE. The MODE function will accept up to 254 separate arguments. 


In the example shown, the formula in D5 is: MODE.SNGL returns the most frequently occurring number in supplied data. For example, If there are no duplicate numbers, the MODE function returns the #N/A error: Note: MODE will return a single value even when there are multiple modes, to return a list of all modes, see the MODE.MULT function


If supplied data does not contain duplicate numbers, MODE.SNGL returns #N/A MODE.SNGL ignores empty cells, the logical values TRUE and FALSE, and text. Arguments can be numbers, names, arrays, or references.

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.