Number of occurances of the larges value in an array?
 

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

tia

Number of occurances of the larges value in an array?
 

is this a single or multi dimensional arra

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

Number of occurances of the larges value in an array?
 

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

Number of occurances of the larges value in an array?
 

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

Number of occurances of the larges value in an array?
 

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