Let A2:A10 house a sample of numeric data...

C2:

=MODE(A2:A10)

C3:

=MODE(IF(ISNUMBER(MATCH($A$2:$A$10,$C$2:C2,0)),"", $A$2:$A$10))

which must be confirmed with control+shift+enter then copied down.

Jdolsak wrote:
I'm working with lists of numbers that should return bi and multi-modal
results when analyzed. MODE() only returns the first mode, and then stops.

Is there a way to get MODE() to return these results? Or is there another
method to get correct results for the modes of bi- and multi-modal data?

Thanks,
Joe Dolsak