Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Dynamic formula
I have a cell, which generates a certain range. I now want to use this range in a formula, which is also generated. E.g.: cell C1000 contains the text $A$1:$A$1000 cell D1000 should now either calculate MAX or MIN via a =IF($B$1000<1234, MAX(cell("contents",$C$1000),MIN(cell("contents",$ C$1000)) As I got a #VALUE error, I tried to minimize the complexity in D1000 to see whether it works at all: =MAX(cell("contents",$C$1000)) but I still get the error. If I replace the cell funciton with the actual range, it works fine, so the range is correct. Even usage of the address function within the MAX function doesn't give me a result. I then assigned D1000 the *text* of the complete MAX function via =CONCATENATE("=MAX(",TEXT(T3,"$A$0"),":",TEXT(U3," $A$0"),")") with T3 containing a 2 and U3 containing a 1000. But now I don't know, how to *execute * this command Any ideas how to dynamically generate functions. Thanks, Peter -- p6er ------------------------------------------------------------------------ p6er's Profile: http://www.excelforum.com/member.php...o&userid=28571 View this thread: http://www.excelforum.com/showthread...hreadid=482348 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with dynamic sum formula | Excel Worksheet Functions | |||
IF formula? | Excel Worksheet Functions | |||
Setting dynamic range in a formula | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Named SUM Formula with relative refernce(s) | Excel Worksheet Functions |