2 dimensional array and freq function?

  • Thread starter Thread starter dabith
  • Start date Start date
D

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
 
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.
 
Thanks for the info Tom.

I guess I'll try manipulating the data using sql
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vba array logic 3
copy a 2 dimensional array to a range 2
Multi-Dimensional Array 17
Multi-Dimensional Array Procedures 2
2 dimensional array 3
Dynamic multi-dimensional array 6
Returning an array from a multi-dimensional array 2
Using Excel statistical functions on a subset of an array 2

Back
Top