T
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
find the number of occurances of the largest value?
tia
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
mudraker
is this a single or multi dimensional arra
T
Tom Ogilvy
If this is an array of cells (a range)
=COUNTIF(A1:C7,MAX(A1:C7))
=COUNTIF(A1:C7,MAX(A1:C7))
T
Todd
Sorry, I wasn't specific enough.
I am using an array like this:
Dim aTableSetValue(1 To 1000, 1 To 1000) as variant
I am using an array like this:
Dim aTableSetValue(1 To 1000, 1 To 1000) as variant
A
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
http://home.pacbell.net/beban are available to your workbook
NumMax = ArrayCountIf(aTableSetValue, Application.Max(aTableSetValue))
Alan Beban