View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
nastech
 
Posts: n/a
Default 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