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 ...
=SUMPRODUCT((G3:G12<>"")*(H3:H12<>""))=SUMPRODUCT((I3:I12<>"")+(J3:J12<>""))You can try these formulas for apples bought with bananas and for oranges or kiwi both.