macOS I need help finding mode(s) in Excel:Mac 2004?

[Britanium]

Not quite programing, but I'm pretty sure you are the people to ask.

I'm doing some stats work in Excel for MAC 2004.

I'm trying to find the modes (more than one mode) of data.

I'll enter something like this:
=MODE(A1:A500)

and it will output a mode. My problem is, I know that there is more than one mode.

My question is, what do I need to enter do have the output display all of the modes?


FYI: I have the following Add-ins: Expander, Data Analysis, and Data Analysis Plus


Thank you!

 

[Le Big Mac]

Try this:

http://www.mrexcel.com/archive2/70100/81213.htm