Hello friends !
I have a problem with the formula, which relates the number of columns.
With one column =AGGREGATE(15,6,$F$2:$F$31/(COUNTIF($F$2:$F$31,$F$2:$F$31)=J2),1+SUMIF(J$1:J1,J2)),the function COUNTIF work.
Which relates the number of columns
=AGGREGATE(15,6,MMULT($A$2:$D$31,{1;1;1;1})/(COUNTIF(MMULT($A$2:$D$31,{1;1;1;1}),MMULT($A$2:$D$31,{1;1;1;1}))=J2),1+SUMIF(J$1:J1,J2)) ,says, there is a mistake in the formula.
Unable to enter this section MMULT($A$2:$D$31,{1;1;1;1}) in COUNTIF .
The formula in cell M2.
Thank you !
I have a problem with the formula, which relates the number of columns.
With one column =AGGREGATE(15,6,$F$2:$F$31/(COUNTIF($F$2:$F$31,$F$2:$F$31)=J2),1+SUMIF(J$1:J1,J2)),the function COUNTIF work.
Which relates the number of columns
=AGGREGATE(15,6,MMULT($A$2:$D$31,{1;1;1;1})/(COUNTIF(MMULT($A$2:$D$31,{1;1;1;1}),MMULT($A$2:$D$31,{1;1;1;1}))=J2),1+SUMIF(J$1:J1,J2)) ,says, there is a mistake in the formula.
Unable to enter this section MMULT($A$2:$D$31,{1;1;1;1}) in COUNTIF .
The formula in cell M2.
Thank you !