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

tia

is this a single or multi dimensional arra

--
Message posted from http://www.ExcelForum.com

If this is an array of cells (a range)

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

--
Regards,
Tom Ogilvy


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

tia

Sorry, I wasn't specific enough.

I am using an array like this:

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



On Mon, 09 Feb 2004 20:40:57 -0500, wrote:

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

tia

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

wrote:
Sorry, I wasn't specific enough.

I am using an array like this:

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



On Mon, 09 Feb 2004 20:40:57 -0500, wrote:


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

tia