Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I reference a range of cells depending on another cell valu
What I am trying to do is write a formula that can be used on a number of my
spreadsheets and will manipulate a range of data. However the length of this range of data varies from sheet to sheet so I want to be able to plug a value into a reference cell that will modify the range that this formula is referencing. Is this possibile and if so how do I do it? An alternative route that might suffice would be something like the offset function IF I could modify the degree of offset based on a value plugged into a reference cell. Many thanks for your help, this is definately slowing me down! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I reference a range of cells depending on another cell valu
Could you use a derivative of this OFFSET and COUNTA Function on Debra's
website? http://www.contextures.com/xlNames01.html#Dynamic -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk "batkinson" wrote in message ... What I am trying to do is write a formula that can be used on a number of my spreadsheets and will manipulate a range of data. However the length of this range of data varies from sheet to sheet so I want to be able to plug a value into a reference cell that will modify the range that this formula is referencing. Is this possibile and if so how do I do it? An alternative route that might suffice would be something like the offset function IF I could modify the degree of offset based on a value plugged into a reference cell. Many thanks for your help, this is definately slowing me down! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Scores of a Range Cells. Highest or lowest depending a parameter | Excel Worksheet Functions | |||
Selecting range in list of range names depending on a cell informa | Excel Discussion (Misc queries) | |||
Reference range of cells and perform subtraction or nothing depending on contents | Excel Worksheet Functions | |||
Changing named range reference depending on a cell's content | Excel Discussion (Misc queries) | |||
How do I reference the same cell as I move through range of cells. | Excel Worksheet Functions |