Forum Discussion
How to find multiple co-relations
Hi I have a data set here , which looks similar to this Order Id apple Banana Orange Kiwi Total 1 2 2 2 3 2 1 3 4 ...
I am not sure whether there is a standard way of doing this? The formula returns the number of times each combination occurs.
The formula is a 365 array formula because I have pretty much forgotten traditional methods even when they may be simpler (more often they are not).