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
|