ExcelBanter - Range of data among cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Range of data among cells (https://www.excelbanter.com/excel-discussion-misc-queries/150435-range-data-among-cells.html)

graph

Range of data among cells

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)?

edward

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)?

Dave Peterson

Range of data among cells

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

graph

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

graph

Range of data among cells

thanks

"Edward" wrote:

=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)?

All times are GMT +1. The time now is 07:35 AM.