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
Bookmarks