| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
indirect with address list
On Mar 11, 3:17*pm, Gary''s Student
wrote: Your workaround is a good one. *Many functions have problems handling a disjoint collects of cells; COUNTIF() is one example. A perfectly valid solution to to removed "disjointness" by creating a nice, compact block of linked cells and let the fussy function operate on them instead. Thanks! that feels good! I've noticed your sig under good solutions before --- Thanks for your helpfulness! -- Clif |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Allow EXCEL INDIRECT(ADDRESS()) and INDIRECT(RANGE()) functions | Excel Worksheet Functions | |||
| using INDIRECT(ADDRESS(...)) | Excel Discussion (Misc queries) | |||
| Indirect(Address(... | Excel Discussion (Misc queries) | |||
| INDIRECT(ADDRESS... Across worksheets | Excel Worksheet Functions | |||
| Indirect and Address in Reference to other sheets | Excel Worksheet Functions | |||
Threaded Mode
