mode function does not work

**moniquem** · 03-06-2013, 04:30 AM

Please see attached. Why is the result N/A when apparently the most recurring is the letter W?

**RHCPgergo** · 03-06-2013, 04:36 AM

The mode function only works with numbers.

If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included.

http://office.microsoft.com/en-us/ex...010335649.aspx

**Fotis1991** · 03-06-2013, 04:37 AM

MODE function, works only with numbers. You need to use MODE with INDEX & MATCH, to get your result.

=INDEX(A1:A23,MODE(MATCH(A1:A23,A1:A23,0)))

**moniquem** · 03-06-2013, 04:38 AM

What can I use in replacement of mode for this matter?

**moniquem** · 03-06-2013, 04:38 AM

Thank you to both of you for the fast response!

Both are really helpful!

**moniquem** · 03-18-2013, 11:45 AM

Does the function =IF(COUNTIF(I937:I938,"---")=COUNT(I937:I938),"-99",INDEX((I937:I938),MODE(MATCH(I937:I938,I937:I938,0)))) will return the symbol --- if it is the most reccurring symbols? I need the mode function to retuen only letters.