| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell references within formulae
I want to reference a particular cell (call it N1018) from within an array
contained in a formula so that the starting row for the array is determined by the number located within the cell N1018, e.g., the formula might read as follows: =median(p(n1018):p37) where the value of N1018 is the row number of cell p(N1018) That is, I want the formula to read =MEDIAN(p15:p37) if the value in N1018 is 15. If the value of N1018 was 6, then the formula would be =MEDIAN(p6:p37), etc. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell references within formulae
Try
=MEDIAN(INDIRECT("P" & N1018 &":P37")) Mike "Jodyeph" wrote: I want to reference a particular cell (call it N1018) from within an array contained in a formula so that the starting row for the array is determined by the number located within the cell N1018, e.g., the formula might read as follows: =median(p(n1018):p37) where the value of N1018 is the row number of cell p(N1018) That is, I want the formula to read =MEDIAN(p15:p37) if the value in N1018 is 15. If the value of N1018 was 6, then the formula would be =MEDIAN(p6:p37), etc. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing multiple worksheet references in formulae | Excel Discussion (Misc queries) | |||
| convert relative cell references to absolute cell references via amacro? | Excel Discussion (Misc queries) | |||
| References to worksheets in formulae | Excel Discussion (Misc queries) | |||
| How to rename references from range names to cell references | Excel Discussion (Misc queries) | |||
| Searching TEXT in formulae, rather than results of formulae | Excel Worksheet Functions | |||
Linear Mode
