Number of occurances of the larges value in an array?

[Todd]

In an array with multiple occurances of any value, is there a way to
find the number of occurances of the largest value?

tia

 

[mudraker]

is this a single or multi dimensional arra

 

[Tom Ogilvy]

If this is an array of cells (a range)

=COUNTIF(A1:C7,MAX(A1:C7))

 

[Todd]

Sorry, I wasn't specific enough.

I am using an array like this:

Dim aTableSetValue(1 To 1000, 1 To 1000) as variant

 

[Alan Beban]

If the functions in the freely downloadable file at
http://home.pacbell.net/beban are available to your workbook

NumMax = ArrayCountIf(aTableSetValue, Application.Max(aTableSetValue))

Alan Beban