| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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)? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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)? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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)? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I sum a range of data (column) that has #num! in some cells | Excel Worksheet Functions | |||
| Test for data in a range of cells | Excel Worksheet Functions | |||
| Finding min/max of adjacent data in a range of cells | Excel Worksheet Functions | |||
| Data Validation (in a range of cells) | Excel Worksheet Functions | |||
| Eliminate empty cells in data range | Excel Discussion (Misc queries) | |||
Linear Mode
