i have range formula
address( 302 ; row() ; 4 ; true)&":"&address( 401 ; row() ; 4 ; true) starting @ row 1 output a302:a401 want find position of text in range.
match("*"&a1&"*";a302:a401;0) i don't know how make work.
so managed find answer. using indirect around address ranges works. have copy paste in different fields , range updates correctly.
=match("*"&a1&"*";indirect(address(302 ; row()-2 ; 4 ; true)&":"&address( 401 ; row()-2 ; 4 ; true));0)
Comments
Post a Comment