"Harold Fuchs" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Franco wrote: > > Hi, > > Has anyone used Base to calculate the median value of a list of numbers? > > > > I'd like to sort and group by zip code and then calculate a median value for > > sales in a given zip code. > > > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > Have you tried using the "median()" function? Assume you have values in > A1 to A50; in cell B1, for example, enter the formula "=median(A1:A50)" > (without the quotes). Seems to work for me ... > > > -- > Harold Fuchs > London, England > Please reply *only* to [email protected]
Hi Harold -- I think you might be referring to Calc. My post referred to Base, which as far as I know does not have a built-in median calculation and would therefore require some sort of work-around. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
