MODE.MULT Solution with AGGREGATE function

[bines53]

Hello friends !

You can do this conversion function ={MODE.MULT(IF(1-ISNUMBER(MATCH($B$2:U21,$X$1:X1,0)),$B$2:U21))}
with AGGREGATE function ?

Thank you !

 

[Somendra Misra]

Hi David,

MODE.MULT function returns multiple max occurring numbers in an array. You formula can also be done with MODE only.
AGGREGATE function don't have this option of MODE or MODE.MULT, it had MODE.SGNL.

Regards,

 

[bines53]

Hi Somendra,

The formula does not return values that are lower
If there is another option that integration (1-ISNUMBER(MATCH

Thank you !