Set external cell filter for a range
 

Hi, I am trying to embed a cell designation for a range, can it be done?
thanks
for each of: (replace the 137 & 1150 with absolute cells?)

=MIN(IF(ISNUMBER(BK137:BK1150),BK137:BK1150,1E+100 ))

and
=SUMPRODUCT(--(LEFT(R137:R1150,1)="x"))

cntrl-shift-enter

Set external cell filter for a range
 

Thanks anyways, realized unlike "in-document" links, cells move with
cut-paste for use of a fixed reference..

"nastech" wrote:

Hi, I am trying to embed a cell designation for a range, can it be done?
thanks
for each of: (replace the 137 & 1150 with absolute cells?)

=MIN(IF(ISNUMBER(BK137:BK1150),BK137:BK1150,1E+100 ))

and
=SUMPRODUCT(--(LEFT(R137:R1150,1)="x"))

cntrl-shift-enter