Microsoft KB Archive/146407

= Microsoft Knowledge Base =

XL: Remarks Section for "MODE" Help Topic is Incorrect
Last reviewed: March 27, 1997

Article ID: Q146407

5.00 7.00 | 5.00

WINDOWS  | MACINTOSH kbdocerr

The information in this article applies to:


 * Microsoft Excel for Windows 95, version 7.0
 * Microsoft Excel for Windows, version 5.0
 * Microsoft Excel for the Macintosh, version 5.0

SUMMARY
The "MODE" worksheet function Help topic reads as follows:

If the data set contains no duplicate data points, MODE returns the #N/A error value This information is incorrect. Rather than the #N/A error value, MODE returns #NUM! error value.

MORE INFORMATION
The MODE worksheet function returns the most frequently occurring value in an array or range of data.