Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
3D function with dynamic reference
I need to create a 3d function whouse argument is dynamically created by
assempling elements from different cells. I've been able to generate the string as I wish according to different variable that might change over time. When I pass that argument to the function I get an error. Is it because it is a 3D string or because I do something wrong? Thanks, Stefano |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
3D function with dynamic reference
can you post what you have?
-- JNW "smaruzzi" wrote: I need to create a 3d function whouse argument is dynamically created by assempling elements from different cells. I've been able to generate the string as I wish according to different variable that might change over time. When I pass that argument to the function I get an error. Is it because it is a 3D string or because I do something wrong? Thanks, Stefano |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
3D function with dynamic reference
This is what I would love to get to: =MIN(JP:IT!$E30).
The cell reference - E30 - chnages dynamically and could be other coordinates such as F31 or D31. The following two examples illustrate how thew formula could change: =MIN(JP:IT!$F31) =MIN(JP:IT!$D31) Therefore the function argument is static in the first part - the reference to multiple sheets - but changes in the cell reference. Currently I have solved it by nesting multiple IF statements, but i would rather prefer to have a more readable formula, and acapable of generating any kind of range according to the inputs present in other cells. Thanks, Stefano "JNW" wrote: can you post what you have? -- JNW "smaruzzi" wrote: I need to create a 3d function whouse argument is dynamically created by assempling elements from different cells. I've been able to generate the string as I wish according to different variable that might change over time. When I pass that argument to the function I get an error. Is it because it is a 3D string or because I do something wrong? Thanks, Stefano |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
3D function with dynamic reference
The formula I would like to generate dynamically looks like this:
=MIN(JP:IT!$E30) I don't have to change the sheet reference (JP:IT!), but focus exclusively on the cell reference (E30). this value could change according to values in other cells used as inputs. Therefore the formula could look like the following two examples: =MIN(JP:IT!$D31) =MIN(JP:IT!$F32) Currently I have solved this issue by nesting multiple IF statements, a solution not particularly smart, and not flexible enough. I f I could dynamically create the 3D formula refence on the fly it would definitely better and a clearer approach. Thanks, Stefano "JNW" wrote: can you post what you have? -- JNW "smaruzzi" wrote: I need to create a 3d function whouse argument is dynamically created by assempling elements from different cells. I've been able to generate the string as I wish according to different variable that might change over time. When I pass that argument to the function I get an error. Is it because it is a 3D string or because I do something wrong? Thanks, Stefano |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
3D function with dynamic reference
The formula I would like to generate dynamically looks like this:
=MIN(JP:IT!$E30) I don't have to change the sheet reference (JP:IT!), but focus exclusively on the cell reference (E30). this value could change according to values in other cells used as inputs. Therefore the formula could look like the following two examples: =MIN(JP:IT!$D31) =MIN(JP:IT!$F32) Currently I have solved this issue by nesting multiple IF statements, a solution not particularly smart, and not flexible enough. I f I could dynamically create the 3D formula refence on the fly it would definitely better and a clearer approach. Thanks, Stefano "JNW" wrote: can you post what you have? -- JNW "smaruzzi" wrote: I need to create a 3d function whouse argument is dynamically created by assempling elements from different cells. I've been able to generate the string as I wish according to different variable that might change over time. When I pass that argument to the function I get an error. Is it because it is a 3D string or because I do something wrong? Thanks, Stefano |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
3D function with dynamic reference
The formula I would like to generate dynamically looks like this:
=MIN(JP:IT!$E30) I don't have to change the sheet reference (JP:IT!), but focus exclusively on the cell reference (E30). this value could change according to values in other cells used as inputs. Therefore the formula could look like the following two examples: =MIN(JP:IT!$D31) =MIN(JP:IT!$F32) Currently I have solved this issue by nesting multiple IF statements, a solution not particularly smart, and not flexible enough. I f I could dynamically create the 3D formula refence on the fly it would definitely better and a clearer approach. Thanks, Stefano "JNW" wrote: can you post what you have? -- JNW "smaruzzi" wrote: I need to create a 3d function whouse argument is dynamically created by assempling elements from different cells. I've been able to generate the string as I wish according to different variable that might change over time. When I pass that argument to the function I get an error. Is it because it is a 3D string or because I do something wrong? Thanks, Stefano |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
3D function with dynamic reference
The formula I would like to generate dynamically looks like this:
=MIN(JP:IT!$E30) I don't have to change the sheet reference (JP:IT!), but focus exclusively on the cell reference (E30). this value could change according to values in other cells used as inputs. Therefore the formula could look like the following two examples: =MIN(JP:IT!$D31) =MIN(JP:IT!$F32) Currently I have solved this issue by nesting multiple IF statements, a solution not particularly smart, and not flexible enough. I f I could dynamically create the 3D formula refence on the fly it would definitely better and a clearer approach. Thanks, Stefano "JNW" wrote: can you post what you have? -- JNW "smaruzzi" wrote: I need to create a 3d function whouse argument is dynamically created by assempling elements from different cells. I've been able to generate the string as I wish according to different variable that might change over time. When I pass that argument to the function I get an error. Is it because it is a 3D string or because I do something wrong? Thanks, Stefano |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
3D function with dynamic reference
The formula looks like this:
=MIN(JP:IT!$E30) The portion that I intend to change dynamically is the cell reference. Alternative variations could look like these: =MIN(JP:IT!$E31) or =MIN(JP:IT!$F32) I have solved this issue by nesting multiple IF statements, a solution that is not flexible enough, and quite cumbersome. Thanks, Stefano "JNW" wrote: can you post what you have? -- JNW "smaruzzi" wrote: I need to create a 3d function whouse argument is dynamically created by assempling elements from different cells. I've been able to generate the string as I wish according to different variable that might change over time. When I pass that argument to the function I get an error. Is it because it is a 3D string or because I do something wrong? Thanks, Stefano |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
3D function with dynamic reference
The formula looks like this:
=MIN(JP:IT!$E30) The portion that I intend to change dynamically is the cell reference. Alternative variations could look like these: =MIN(JP:IT!$E31) or =MIN(JP:IT!$F32) I have solved this issue by nesting multiple IF statements, a solution that is not flexible enough, and quite cumbersome. Thanks, Stefano "smaruzzi" wrote: I need to create a 3d function whouse argument is dynamically created by assempling elements from different cells. I've been able to generate the string as I wish according to different variable that might change over time. When I pass that argument to the function I get an error. Is it because it is a 3D string or because I do something wrong? Thanks, Stefano |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
3D function with dynamic reference
I should add that the cell reference is formed by analyzing two other cells
from where the column and row reference is derived extracting some information from a text string. Thanaks, Stefano "smaruzzi" wrote: The formula looks like this: =MIN(JP:IT!$E30) The portion that I intend to change dynamically is the cell reference. Alternative variations could look like these: =MIN(JP:IT!$E31) or =MIN(JP:IT!$F32) I have solved this issue by nesting multiple IF statements, a solution that is not flexible enough, and quite cumbersome. Thanks, Stefano "smaruzzi" wrote: I need to create a 3d function whouse argument is dynamically created by assempling elements from different cells. I've been able to generate the string as I wish according to different variable that might change over time. When I pass that argument to the function I get an error. Is it because it is a 3D string or because I do something wrong? Thanks, Stefano |
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
3D function with dynamic reference
What is JP?
-- JNW "smaruzzi" wrote: I should add that the cell reference is formed by analyzing two other cells from where the column and row reference is derived extracting some information from a text string. Thanaks, Stefano "smaruzzi" wrote: The formula looks like this: =MIN(JP:IT!$E30) The portion that I intend to change dynamically is the cell reference. Alternative variations could look like these: =MIN(JP:IT!$E31) or =MIN(JP:IT!$F32) I have solved this issue by nesting multiple IF statements, a solution that is not flexible enough, and quite cumbersome. Thanks, Stefano "smaruzzi" wrote: I need to create a 3d function whouse argument is dynamically created by assempling elements from different cells. I've been able to generate the string as I wish according to different variable that might change over time. When I pass that argument to the function I get an error. Is it because it is a 3D string or because I do something wrong? Thanks, Stefano |
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
3D function with dynamic reference
JP and IT being the first and the last sheets from which I want to extract a
cell value. Thanks, Stefano "JNW" wrote: What is JP? -- JNW "smaruzzi" wrote: I should add that the cell reference is formed by analyzing two other cells from where the column and row reference is derived extracting some information from a text string. Thanaks, Stefano "smaruzzi" wrote: The formula looks like this: =MIN(JP:IT!$E30) The portion that I intend to change dynamically is the cell reference. Alternative variations could look like these: =MIN(JP:IT!$E31) or =MIN(JP:IT!$F32) I have solved this issue by nesting multiple IF statements, a solution that is not flexible enough, and quite cumbersome. Thanks, Stefano "smaruzzi" wrote: I need to create a 3d function whouse argument is dynamically created by assempling elements from different cells. I've been able to generate the string as I wish according to different variable that might change over time. When I pass that argument to the function I get an error. Is it because it is a 3D string or because I do something wrong? Thanks, Stefano |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
Using SUMIF Function with a named cell reference as value in CRITE | Excel Worksheet Functions | |||
information function - does cell contain reference | Excel Worksheet Functions | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel |