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 ...
Another way - see the attached workbook.
Same solution again but this time using MAKEARRAY:
= MAKEARRAY(4,4,
LAMBDA(r,c,
IF(r<>c,
COUNTIFS(
INDEX(qty,,r), ">0",
INDEX(qty,,c), ">0"
),
"-"
)
)
)