2 dimensional array and freq function?

[dabith]

Hey all,

A newbie hoping you can help with a problem I am having regarding
applying the frequency function to a 2 dimensional array.

I have my 2 dimensional array populated with random numbers and I want
to apply the frequency function to the array but I have no idea how it
can be done.

Is it possible to do so, or can it only be applied to actual ranges on
a spreadsheet? If it is not possible can someone please suggest another
approach?

(The reason I am using an array is because I want to use more rows than
is allowed on a spreadsheet. ie more than 65536 rows)

Any help greatly appreciated.

Thanks

 

[Tom Ogilvy]

From Help:

FREQUENCY(data_array,bins_array)

Data_array is an array of or reference to a set of values for which you
want to count frequencies. If data_array contains no values, FREQUENCY
returns an array of zeros.

However I doubt it will work with an array with more than 65536 rows and may
not work with that many depending on version.

You might have to roll your own.

 

[dabith]

Thanks for the info Tom.

I guess I'll try manipulating the data using sql