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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
