Can I calculate a statistical range (largest minus smallest)?
=max(A1:A10)-min(A1:A10)
Adjust range reference to suit your needs.
Dave
--
Brevity is the soul of wit.
"lolee624" wrote:
How can I calculate a statistical range (largest number minus smallest number
) when numbers are in random order?
|