Returns the most frequently occurring value in a dataset.
تعمل هذه الدالة في Google Sheets كما تعمل في Excel تمامًا — بالصياغة والوسائط نفسها.
MODE(number1, [number2], …)The MODE function identifies the value that appears most often in a given set of numbers. If there are multiple values with the same highest frequency, it returns the first one encountered. Note that this function is available for compatibility with older versions of Excel; for newer versions, MODE.SNGL or MODE.MULT are recommended.
=MODE(1, 2, 3, 3, 4)النتيجة: 3
The number 3 appears twice, which is more frequent than any other number.
If no two numbers are the same, the function returns the #N/A error.