• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Mean, median and mode


New Member
Is there a good/easy formula to use when trying to find the mean, median and mode for a column? If so, can someone post it? I'd like to make it as easy as possible (obviously!).



Excel Ninja
For a column ...
If You data is in A-column then write somewhere else
=IFERROR("#" &AVERAGE(A:A) & "#" & MEDIAN(A:A) & "#" & MODE(A:A),"Err")
Some functions need valid data to get results.


Excel Ninja
Moderator Note:
You, kleini, should reread Forum Rules.
There are sentences, if someone uses Cross-Posting.
You, kleini, seems to skipped all of those ... those rules are for You, kleini, too.
Ps. Same kind of rules are in every Forum.