| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc,sci.math
|
|||
|
|||
how to easily vary (parametrize) array sizes in Excel?
Suppose I have a column of numerical data, say, in Column A.
I want to compute average, e.g., average(A1:A1000). But sometimes I want to compute average(A23:A1000) or average(A48:A1000). Is it possible for me to input the bottom of the range, say "A36", in another cell, such as C1, and then compute average(whatever cell is specified in cell C1,A1000)? How do I do this simply? MD |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In excel, how do I vary a cell over a data range & see its effect? | Charts and Charting in Excel | |||
| vary row colors in excel? | Excel Discussion (Misc queries) | |||
| excel should let you vary error bars for individual points | Charts and Charting in Excel | |||
| vary the vlookup array depending on the value in a cell | Excel Worksheet Functions | |||
| Fill array with fn variables that vary across and down? | Excel Worksheet Functions | |||
Threaded Mode
