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

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

  1. Britanium macrumors member

    Joined:
    Mar 9, 2007
    #1
    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!
     

Share This Page