Hi,
I'm so glad, the new formula is working well. I also attach another workbook.
The formula for cell V2 on worksheets (Singles, Pairs, Triplets, Quadruplets, Quintuplets, Sextuplets):
=SOMMA(SE(FREQUENZA(SE($A$2:$M$14=O2;RIF.RIGA($A$2 :$M$14);0);RIF.RIGA($A$2:$A$14)-1)=1;1;0))
=SOMMA(SE(FREQUENZA(SE($A$2:$M$14=O2;RIF.RIGA($A$2 :$M$14);SE($A$2:$M$14=P2;RIF.RIGA($A$2:$M$14);0)); RIF.RIGA($A$2:$A$14)-1)=2;1;0))
=SOMMA(SE(FREQUENZA(SE($A$2:$M$14=O2;RIF.RIGA($A$2 :$M$14);SE($A$2:$M$14=P2;RIF.RIGA($A$2:$M$14);SE($ A$2:$M$14=Q2;RIF.RIGA($A$2:$M$14);0)));RIF.RIGA($A $2:$A$14)-1)=3;1;0))
=SOMMA(SE(FREQUENZA(SE($A$2:$M$14=O2;RIF.RIGA($A$2 :$M$14);SE($A$2:$M$14=P2;RIF.RIGA($A$2:$M$14);SE($ A$2:$M$14=Q2;RIF.RIGA($A$2:$M$14);SE($A$2:$M$14=R2 ;RIF.RIGA($A$2:$M$14);0))));RIF.RIGA($A$2:$A$14)-1)=4;1;0))
=SOMMA(SE(FREQUENZA(SE($A$2:$M$14=O2;RIF.RIGA($A$2 :$M$14);SE($A$2:$M$14=P2;RIF.RIGA($A$2:$M$14);SE($ A$2:$M$14=Q2;RIF.RIGA($A$2:$M$14);SE($A$2:$M$14=R2 ;RIF.RIGA($A$2:$M$14);SE($A$2:$M$14=S2;RIF.RIGA($A $2:$M$14);0)))));RIF.RIGA($A$2:$A$14)-1)=5;1;0))
=SOMMA(SE(FREQUENZA(SE($A$2:$M$14=O2;RIF.RIGA($A$2 :$M$14);SE($A$2:$M$14=P2;RIF.RIGA($A$2:$M$14);SE($ A$2:$M$14=Q2;RIF.RIGA($A$2:$M$14);SE($A$2:$M$14=R2 ;RIF.RIGA($A$2:$M$14);SE($A$2:$M$14=S2;RIF.RIGA($A $2:$M$14);SE($A$2:$M$14=T2;RIF.RIGA($A$2:$M$14);0) )))));RIF.RIGA($A$2:$A$14)-1)=6;1;0))
I hope, it will be easier for you to understand the logic of the formulas.
|