View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default 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?