Mode
Also written: MODE.SNGL, MODE.MULT
The most common value. MODE.SNGL returns one mode (and #N/A if nothing repeats); MODE.MULT lists all tied modes. For categories, count with COUNTIF instead.
Also written: MODE.SNGL, MODE.MULT
The most common value. MODE.SNGL returns one mode (and #N/A if nothing repeats); MODE.MULT lists all tied modes. For categories, count with COUNTIF instead.