Adjustin Mode Function To show No Mode

[andreascostas]

I am using:
=TEXTJOIN(", ",,INDEX(SMALL(MODE.MULT(F15:F23),ROW(INDIRECT("1:"&COUNT(MODE.MULT(F15:F23))))),0))
To find multiple modes in a set of data. When there is no mode I get #N/A as an answer.
Is there a way to adjust the formula to show “no mode” without the quotation marks of course?
When there is no mode my students think that the mode is 0 when there is no mode. I want them to understand that 0 and no mode are not the same think. Thanks for all the help. If there is an easier way to do this am open to it.

 

[Rick Rothstein]

I am using:
=TEXTJOIN(", ",,INDEX(SMALL(MODE.MULT(F15:F23),ROW(INDIRECT("1:"&COUNT(MODE.MULT(F15:F23))))),0))
To find multiple modes in a set of data. When there is no mode I get #N/A as an answer.
Is there a way to adjust the formula to show “no mode” without the quotation marks of course?
When there is no mode my students think that the mode is 0 when there is no mode. I want them to understand that 0 and no mode are not the same think. Thanks for all the help. If there is an easier way to do this am open to it.

Try wrapping your formula in an IFERROR function call and use "No Mode" as the second argument.

 

[andreascostas]

I always tell my students that "if you know what you are doing then everything is easy".
I knew there was an easy way to do this, I just didn't know it. Thank You, again for your help. Simple so simple!!!