Here, I need to find out the most frequently occurring or repetitive score in a range of data by using MODE.MULT FUNCTION. The below-mentioned table it contains the Name of the student in the Name column (G8 to G24) & the score of each student (H8 to H24). Let’s check out this with the below-mentioned example. MODE.MULT returns more than one result if multiple modes are entered as an array formula. returns the most frequently occurring or repetitive score or value 55 as a result in the cell C26. Click ok.Īfter entering the number1 argument, = MODE(C8:C24), i.e. So that column range will get selected, i.e. To enter the Number 1 argument, click inside cell C8 and you’ll see the cell selected, then Select the cells till C24. =MODE.SNGL (C8: C24) Here, the score data is present in the range (C8 to C24) for which we need to apply MODE.SNGL function. Let us understand the working of the MODE Function in Excel by some MODE Formula examples.Ī dialog box appears where arguments for MODE.SNGL function needs to be filled or entered i.e. MODE Function in Excel is very simple and easy to use. TRANSPOSE(MODE.MULT(number1,number2,…)) How to Use the MODE Function in Excel? To return a horizontal array, transpose function is added along with MODE.MULT function i.e. MODE.MULT returns a vertical array of the most frequently occurring or repetitive values in an array or range of data & return more than one result if there are multiple modes & if it is entered as an array formula (Note: If the MODE.MULT formula is not entered as an array formula, then it returns the single result as 8 similar to MODE.SNGL function). MODE.SNGL function returns a single-mode & considers first repetitive numeric value whereas MODE.MULT function returns an array of all of the modes. Note: 255 numbers can be supplied as separate arguments. number2 (Optional OR not required) – Arrays of cell reference or numeric values (set of one or more numeric values) for which we have to calculate the mode.

number1 (compulsory OR required argument) – Arrays of cell reference or numeric values (set of one or more numeric values) for which we have to calculate the mode.

The MODE Formula in Excel has a below-mentioned argument : Excel functions, formula, charts, formatting creating excel dashboard & others

How to find a range in excel