Thread: Range of data among cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
edward edward is offline
external usenet poster
  
Posts: 87
Default Range of data among cells
=MAX(array)-(MIN(array))

"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)?
Reply With QuoteReply With Quote