| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula - Dynamic Range
Based on the current activecell, I want to create a median calculation that
will include the continuous range which is directly above the active cell. So, if the Activecell were A10 and there was a range of data in cells A5:A9, I would want to include in cell A10 = Median(A5:A9). The code needs to be dynamic so that it includes the continuous range directly above the cell, which will vary. Thanks. Activecell.FormulaR1C1 = ????? Jason |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for Dynamic Range? | New Users to Excel | |||
| Cant get dynamic range formula to work. | Excel Worksheet Functions | |||
| Copying Formula into a Dynamic Range | Excel Programming | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| formula to set up dynamic range in names | Excel Worksheet Functions | |||
Threaded Mode
