View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Alan Beban[_4_] Alan Beban[_4_] is offline
external usenet poster
 
Posts: 171
Default 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