Thread
:
Number of occurances of the larges value in an array?
View Single Post
#
5
Posted to microsoft.public.excel.programming
Alan Beban[_4_]
external usenet poster
Posts: 171
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
Reply With Quote
Alan Beban[_4_]
View Public Profile
Find all posts by Alan Beban[_4_]