Forum Discussion
Solved
Excel Challenge
I have big problem in writing Excel formula for the following problem: I have Three feature of my costumer I want to separate my costumers by these three features and give them Index 1, 2 and 3, ...
=MMULT(--(COUNTIFS($B$2:$B$17,B2,$A$2:$A$17,{"A","B"})>0),{1;2})
=MMULT(--(COUNTIFS($B$2:$B$17,B2,$A$2:$A$17,{"A","B"})>0),{1;2})