View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
graph graph is offline
external usenet poster
 
Posts: 3
Default Range of data among cells

Thanks much

"Dave Peterson" wrote:

Maybe something like:

=max(a1:a3)-min(a1:a3)


graph wrote:

Is there a function that will display the range of data from selected cells?
i.e. if i have 3 cells containing the numbers 2, 9 & 13 the range would be 11
(13-2)?


--

Dave Peterson