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

Discussion in 'Mac Programming' started by Britanium, Apr 30, 2008.

  1. Britanium macrumors member

    Mar 9, 2007
    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:

    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!

Share This Page