Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

Britanium

macrumors member
Original poster
Mar 9, 2007
73
0
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!
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.