Mode Property

Mode returns the data value or values that appear most often in the column from which the statistics were calculated. Returns a variant. This is a read-only property.

Syntax

object.Mode( Col )

Parameter	Type	Description
Col	Long	optional, default=1

Example

This example demonstrates how to return the mode or modes of the data values in column C.

Debug.Print "Mode(s) "; Stats.Mode(3)

Used by: WksStatistics object