**Public Function CountEqual( _
ByVal vEqual As Variant _
, ParamArray vValues() As Variant _
) As Variant**

**Count number of numeric arguments equal to the value vEqual. **

**Examples:** CountEqual(1, 4, 1, 5, 1, 6, 1) = 3
CountEqual(3, Array(1, 2, 3, 4)) = 1
CountEqual(150, SampleData) = 10

**See also:** Count Function
StatVarType Property

**vEqual:** The values whose number of occurrences within vValues is to be counted.

**vValues:** The values that are to be counted if they equal vEqual. Can be numbers, one-dimensional numeric arrays, one-dimensional Variant arrays, one-dimensional Variant arrays with embedded arrays, or any combination of these. The current setting of the StatVarType Property determines which numeric data types are recognized by this function.

**Return value:** Function returns a count of the numeric values which equal vEqual. Copyright 1996-1999 Entisoft

Entisoft Tools is a trademark of Entisoft.