N
nastech
hi, trying to make a hyperlink work, that is used "in" document where
sub-destinations are all -progressively id'd as "dn" by the friendly name in
the hyperlink.
the problem is the reference to the column / cell the formula currently
occupies.
answer would be to change the following formula to be offset +1 for the 4
copies of the range. guesse might have to remove the "$" sign from the
beginning of the range??.. to make it dynamic.
purpose: to be able to paste formula down the document, and be able to
follow "dn" links to sub sections.
is it possible to add the offset to the range in this manner? thanks.
note: array (cntrl-shift-enter)
=HYPERLINK(IF(ISNA(INDEX(ROW($AT$183:$AT$1156)-ROW($AT$183),MATCH(TRUE,EXACT($AT$183:$AT$1156,"dn"),0))),"",
"#"&CELL("address",OFFSET(INDIRECT(SUBSTITUTE(SUBSTITUTE(CELL("address",$AT183),"$",""),ROW(),"")&INDEX(ROW($AT$183:$AT$1156),MATCH(TRUE,EXACT($AT$183:$AT$1156,"dn"),0))),$Z$3,0))),"dn")
sub-destinations are all -progressively id'd as "dn" by the friendly name in
the hyperlink.
the problem is the reference to the column / cell the formula currently
occupies.
answer would be to change the following formula to be offset +1 for the 4
copies of the range. guesse might have to remove the "$" sign from the
beginning of the range??.. to make it dynamic.
purpose: to be able to paste formula down the document, and be able to
follow "dn" links to sub sections.
is it possible to add the offset to the range in this manner? thanks.
note: array (cntrl-shift-enter)
=HYPERLINK(IF(ISNA(INDEX(ROW($AT$183:$AT$1156)-ROW($AT$183),MATCH(TRUE,EXACT($AT$183:$AT$1156,"dn"),0))),"",
"#"&CELL("address",OFFSET(INDIRECT(SUBSTITUTE(SUBSTITUTE(CELL("address",$AT183),"$",""),ROW(),"")&INDEX(ROW($AT$183:$AT$1156),MATCH(TRUE,EXACT($AT$183:$AT$1156,"dn"),0))),$Z$3,0))),"dn")