2 dimensional array and freq function?
 

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


--
dabith
------------------------------------------------------------------------
dabith's Profile: http://www.excelforum.com/member.php...o&userid=10566
View this thread: http://www.excelforum.com/showthread...hreadid=472314

2 dimensional array and freq function?
 

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.

--
Regards,
Tom Ogilvy


"dabith" wrote in
message ...

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


--
dabith
------------------------------------------------------------------------
dabith's Profile:
http://www.excelforum.com/member.php...o&userid=10566
View this thread: http://www.excelforum.com/showthread...hreadid=472314

2 dimensional array and freq function?
 

Thanks for the info Tom.

I guess I'll try manipulating the data using sql

--
dabit
-----------------------------------------------------------------------
dabith's Profile: http://www.excelforum.com/member.php...fo&userid=1056
View this thread: http://www.excelforum.com/showthread.php?threadid=47231