Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Change row selection
I want to chage the row selection on a function by using a cell reference
"A(B2)" so when I change "B2" to 5 the function will read "A5" TXS |
#2
|
|||
|
|||
Hi Farrel,
try this: =INDIRECT("A"&B2) Regards, KL "Farrel" wrote in message ... I want to chage the row selection on a function by using a cell reference "A(B2)" so when I change "B2" to 5 the function will read "A5" TXS |
#3
|
|||
|
|||
Hi,
Try =INDIRECT("A"&B2) which gives you the value in the cell A5. I think that's what you mean. HTH David "Farrel" wrote: I want to chage the row selection on a function by using a cell reference "A(B2)" so when I change "B2" to 5 the function will read "A5" TXS |
#4
|
|||
|
|||
Hey txs for the Help
but why =SUBTOTAL(1,Sheet2!C3:Sheet2!(INDIRECT("c"&Sheet2! B1))) doest work? "KL" wrote: Hi Farrel, try this: =INDIRECT("A"&B2) Regards, KL "Farrel" wrote in message ... I want to chage the row selection on a function by using a cell reference "A(B2)" so when I change "B2" to 5 the function will read "A5" TXS |
#5
|
|||
|
|||
this should work:
=SUBTOTAL(1,INDIRECT("Sheet2!C3:C"&Sheet2!B1)) KL "Farrel" wrote in message ... Hey txs for the Help but why =SUBTOTAL(1,Sheet2!C3:Sheet2!(INDIRECT("c"&Sheet2! B1))) doest work? "KL" wrote: Hi Farrel, try this: =INDIRECT("A"&B2) Regards, KL "Farrel" wrote in message ... I want to chage the row selection on a function by using a cell reference "A(B2)" so when I change "B2" to 5 the function will read "A5" TXS |
#6
|
|||
|
|||
....or
=SUBTOTAL(1,INDIRECT("Sheet2!"&CELL("address",C3)& ":C"&Sheet2!B1)) "KL" wrote in message ... this should work: =SUBTOTAL(1,INDIRECT("Sheet2!C3:C"&Sheet2!B1)) KL "Farrel" wrote in message ... Hey txs for the Help but why =SUBTOTAL(1,Sheet2!C3:Sheet2!(INDIRECT("c"&Sheet2! B1))) doest work? "KL" wrote: Hi Farrel, try this: =INDIRECT("A"&B2) Regards, KL "Farrel" wrote in message ... I want to chage the row selection on a function by using a cell reference "A(B2)" so when I change "B2" to 5 the function will read "A5" TXS |
#7
|
|||
|
|||
Damn! you're good !!!
TXS "KL" wrote: this should work: =SUBTOTAL(1,INDIRECT("Sheet2!C3:C"&Sheet2!B1)) KL "Farrel" wrote in message ... Hey txs for the Help but why =SUBTOTAL(1,Sheet2!C3:Sheet2!(INDIRECT("c"&Sheet2! B1))) doest work? "KL" wrote: Hi Farrel, try this: =INDIRECT("A"&B2) Regards, KL "Farrel" wrote in message ... I want to chage the row selection on a function by using a cell reference "A(B2)" so when I change "B2" to 5 the function will read "A5" TXS |
#8
|
|||
|
|||
Can be set up in a less expensive way:
=SUBTOTAL(1,Sheet2!$C$3:INDEX(Sheet2!$C:$C,B1)) KL wrote: ...or =SUBTOTAL(1,INDIRECT("Sheet2!"&CELL("address",C3)& ":C"&Sheet2!B1)) "KL" wrote in message ... this should work: =SUBTOTAL(1,INDIRECT("Sheet2!C3:C"&Sheet2!B1)) KL "Farrel" wrote in message ... Hey txs for the Help but why =SUBTOTAL(1,Sheet2!C3:Sheet2!(INDIRECT("c"&Sheet2! B1))) doest work? "KL" wrote: Hi Farrel, try this: =INDIRECT("A"&B2) Regards, KL "Farrel" wrote in message ... I want to chage the row selection on a function by using a cell reference "A(B2)" so when I change "B2" to 5 the function will read "A5" TXS -- [1] The SumProduct function should implicitly coerce the truth values to their Excel numeric equivalents. [2] The lookup functions should have an optional argument for the return value, defaulting to #N/A in its absence. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Change Color - Need Help | New Users to Excel | |||
Running code on a drop down selection change | Excel Worksheet Functions | |||
excel change default column sort to current selection | Excel Worksheet Functions | |||
Change cell back color on click | Excel Discussion (Misc queries) | |||
In Excel 2000, can I change the direction of the move selection a. | Excel Discussion (Misc queries) |