danlu
05-13-2008, 01:33 PM
Hi,
I would like to capture all cells that fullfill some criteria into a Range or variable (or something else appropriate) so that these cell references can be worked on by another formula by referencing this named range containing the cell references. Ex of other formulas that would use the defined range for some operation are formulas like SUM, COUNT or AVG.
One important thing about the cells that fullfill some criteria and thus should be included in the named range is that these cells may not be placed directly after each other and therefore the defined range could be a discontinous area. For ex it could consist of the cells A1,A2, B4, M1101, N10,N11,N12,P504.
Is this possible to have a named range defined by cells not placed in direct order after each other?
If this is possible, could a way to define this discontinous area be to:
First create a function (or procedure) which contains the logic for finding which cells meet some criteria defined in this function(procedure) and then
Secondly set the defined range equal to this function(procedure)'s output.
I would like to capture all cells that fullfill some criteria into a Range or variable (or something else appropriate) so that these cell references can be worked on by another formula by referencing this named range containing the cell references. Ex of other formulas that would use the defined range for some operation are formulas like SUM, COUNT or AVG.
One important thing about the cells that fullfill some criteria and thus should be included in the named range is that these cells may not be placed directly after each other and therefore the defined range could be a discontinous area. For ex it could consist of the cells A1,A2, B4, M1101, N10,N11,N12,P504.
Is this possible to have a named range defined by cells not placed in direct order after each other?
If this is possible, could a way to define this discontinous area be to:
First create a function (or procedure) which contains the logic for finding which cells meet some criteria defined in this function(procedure) and then
Secondly set the defined range equal to this function(procedure)'s output.