search a column for a character..
in case anyone wanted to know how to hyperlink down to next occurance of a
character/s in a column, e.g.: "dn" to next.. bookmark you choose:
(is a long formula, but works, address $A468 is cell formula in, $AA$3 is
number of cells size of screen..)
=HYPERLINK(IF(ISNA(INDEX(ROW(OFFSET($AX468:$AX$195 6,1,0))-ROW(OFFSET($AX468,1,0)),MATCH(TRUE,OFFSET($AX468:$ AX$1956,1,0)="dn",0))),"","#"&CELL("address",OFFSE T(INDIRECT(SUBSTITUTE(SUBSTITUTE(CELL("address",$A 468),"$",""),ROW(),"")&INDEX(ROW(OFFSET($AX468:$AX $1956,1,0)),MATCH(TRUE,OFFSET($AX468:$AX$1956,1,0) ="dn",0))),$AA$3,0))),"dn")
"nastech" wrote:
was wondering if it is possible to have a formula tell you the next line
number / the first occurance of a letter, "x", in one column? thanks
|