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