N
nastech
hi, trying to find way to locate text "up" from current position. not sure
which function / how to use. have been looking at: MATCH, LOOKUP.. thanks
example have for find last number in a column is:
=P54=LOOKUP(9.99999999999999E+307,P$24
$59)
-----
example using for finding next instance "down" from current position is:
MATCH(TRUE,OFFSET($AT427:$AT$1231,1,0)="dn",0)
array portion: guessing would be able to search from fixed top position of
document, down to current position. e.g.: $AT$128:$AT427,-1
which function / how to use. have been looking at: MATCH, LOOKUP.. thanks
example have for find last number in a column is:
=P54=LOOKUP(9.99999999999999E+307,P$24
$59)-----
example using for finding next instance "down" from current position is:
MATCH(TRUE,OFFSET($AT427:$AT$1231,1,0)="dn",0)
array portion: guessing would be able to search from fixed top position of
document, down to current position. e.g.: $AT$128:$AT427,-1