G
Guest
1. Trying to find the location of the maximum number, in a column (just row
#).
(some material working with is below)
2. Goal, if have to send result to separate cell?, is to be able to make a
hyperlink that will let me navigate quickly to item. (thanks), example:
=HYPERLINK($AA$5&V9,"h")
3. other: Desparately trying to figure way to have links "in document"
that:
"expand / contract" in location (for in-document link).
i.e.: right click cell, hyperlink, in document, cell reference: does not
move with reference lines, as lines move.. (causing major delays in work,
re-applying cell reference every few minutes is too crazy) IS there a
check-box somewhere, I am missing?????????????????????, thanks
have the following working with:
=MAX(IF(ISNUMBER(BQ125:BQ727),BQ125:BQ727,-1E+100))
reference row #'s, for upper lower limits (where reference lines are):
=CELL("row",A1099) (moves as expands / contracts)
used to ref other work (upper-lower limits) such as
=IF($F$13="U",SUMPRODUCT(--(C125:C727="p3")),IF($F$13="L",SUMPRODUCT(--(C727:C1099="p3")),SUMPRODUCT(--(C125:C1099="p3"))))
-------------------
also of interest (not related here), column letter formula:
=SUBSTITUTE(SUBSTITUTE(CELL("address",A11),"$",""),ROW(),"")
number of occurances:
=SUMPRODUCT(--(LEFT(AI125:AI1099,1)={"u","d"}))
number of occurances, different columns:
=SUMPRODUCT(--(LEFT(BA80:BA1099,1)="x"),--(E80:E1099<>"x"))
#).
(some material working with is below)
2. Goal, if have to send result to separate cell?, is to be able to make a
hyperlink that will let me navigate quickly to item. (thanks), example:
=HYPERLINK($AA$5&V9,"h")
3. other: Desparately trying to figure way to have links "in document"
that:
"expand / contract" in location (for in-document link).
i.e.: right click cell, hyperlink, in document, cell reference: does not
move with reference lines, as lines move.. (causing major delays in work,
re-applying cell reference every few minutes is too crazy) IS there a
check-box somewhere, I am missing?????????????????????, thanks
have the following working with:
=MAX(IF(ISNUMBER(BQ125:BQ727),BQ125:BQ727,-1E+100))
reference row #'s, for upper lower limits (where reference lines are):
=CELL("row",A1099) (moves as expands / contracts)
used to ref other work (upper-lower limits) such as
=IF($F$13="U",SUMPRODUCT(--(C125:C727="p3")),IF($F$13="L",SUMPRODUCT(--(C727:C1099="p3")),SUMPRODUCT(--(C125:C1099="p3"))))
-------------------
also of interest (not related here), column letter formula:
=SUBSTITUTE(SUBSTITUTE(CELL("address",A11),"$",""),ROW(),"")
number of occurances:
=SUMPRODUCT(--(LEFT(AI125:AI1099,1)={"u","d"}))
number of occurances, different columns:
=SUMPRODUCT(--(LEFT(BA80:BA1099,1)="x"),--(E80:E1099<>"x"))