| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell Reference with Range Name | Excel Worksheet Functions | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| copying cell names | Excel Discussion (Misc queries) | |||
| macro help | Excel Discussion (Misc queries) | |||
| Reveal cell formats and extendable range in tool/statusbar/icon. | Excel Worksheet Functions | |||
Hybrid Mode
