Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dynamically set a range?
Is there a way to dynamically set a range? For instance... can I have a formula that includes a range (Ax:Ay) where I can set the values of x and y based on the value of another cell so that in one case, the range may be A1:A80 and in another it may be A50:A60 and so on? Thanks. -- BKGT ------------------------------------------------------------------------ BKGT's Profile: http://www.excelforum.com/member.php...o&userid=33862 View this thread: http://www.excelforum.com/showthread...hreadid=536778 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dynamically set a range?
On Thu, 27 Apr 2006 08:17:57 -0500, BKGT
wrote: Is there a way to dynamically set a range? For instance... can I have a formula that includes a range (Ax:Ay) where I can set the values of x and y based on the value of another cell so that in one case, the range may be A1:A80 and in another it may be A50:A60 and so on? Thanks. Use the Indirect Function If your x & y variable cells are say B1 & B2 then with B1=50 and B2=60 and if (say) you're summing A50:A60, your formula would be =SUM(INDIRECT("A"&B1&":A"&B2)) HTH __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dynamically set a range?
Hi
Like this: =SUM(INDIRECT(A1)) , where A1 contains string like "A1:A80" -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) "BKGT" wrote in message ... Is there a way to dynamically set a range? For instance... can I have a formula that includes a range (Ax:Ay) where I can set the values of x and y based on the value of another cell so that in one case, the range may be A1:A80 and in another it may be A50:A60 and so on? Thanks. -- BKGT ------------------------------------------------------------------------ BKGT's Profile: http://www.excelforum.com/member.php...o&userid=33862 View this thread: http://www.excelforum.com/showthread...hreadid=536778 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dynamically set a range?
Great. That worked for me. Thanks for the help and the quick responses. -- BKGT ------------------------------------------------------------------------ BKGT's Profile: http://www.excelforum.com/member.php...o&userid=33862 View this thread: http://www.excelforum.com/showthread...hreadid=536778 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
UDF is updateing cells on another sheet with count from current sheet. | Excel Discussion (Misc queries) | |||
FORMULA at Source range (in Data-validation-List) gives wrong re | Excel Worksheet Functions | |||
Help with using range names in sum function | Excel Worksheet Functions | |||
Array to named range conversion... | Excel Discussion (Misc queries) | |||
How can I dynamically eliminate blank cells in a given range in E. | Excel Worksheet Functions |