Median and mode

**maestrodos** · 06-28-2012, 01:24 PM

Are there other ways to make a code for median and mode aside from what is shown in this page. http://eqns2codes.blogspot.com

**Richard Buttrey** · 06-28-2012, 01:50 PM

Well there are two standard functions =MEDIAN() and =MODE() which both take a range of values. Is that what you're meaning?

**maestrodos** · 06-29-2012, 08:46 PM

.well, what i mean is that i want to create a vba sub containing those functions.

**Richard Buttrey** · 06-30-2012, 04:45 AM

Then why not just use VBA to code it.

i.e. Range("Mycell") =WorksheetFunction.Median("your_range")

**maestrodos** · 07-01-2012, 10:40 PM

okay thanks. anything else?

Re: Median and mode