I just took a look at what Shane Devenshire posted.
His method is a far better solution.
It only requires one formula and you can use it for average, median and stdev.
(I still have and refer to the book he helped author in 1994 - "Excel Professional Techniques")
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)