S
Sam via OfficeKB.com
Hi All,
I require a Formula to produce the Arithmetical MODE for numerical values
taking into account the following:
Using Dynamic Named Range "Results" - spans 15 Columns and many Rows.
Dynamic Name "Results" is Defined as Refers To =OFFSET(History!$A$18,1,0,
COUNT(History!$A:$A),15)
Working with Auto-Filtered data so calculations need to display results for
Visible Filtered Cells.
Dynamic Range "Results" needs to be Offset one column to the right,
calculations will include columns 2-15.
Cells housing Formulas that return "" (blank) to be excluded from
calculations
Below is a link to a similar past Thread
http://www.officekb.com/Uwe/Forum.a...-cells-in-Multiple#[email protected]
Would appreciate a Formula that can incorporate the Dynamic Named Range
"Results".
Thanks
Sam
I require a Formula to produce the Arithmetical MODE for numerical values
taking into account the following:
Using Dynamic Named Range "Results" - spans 15 Columns and many Rows.
Dynamic Name "Results" is Defined as Refers To =OFFSET(History!$A$18,1,0,
COUNT(History!$A:$A),15)
Working with Auto-Filtered data so calculations need to display results for
Visible Filtered Cells.
Dynamic Range "Results" needs to be Offset one column to the right,
calculations will include columns 2-15.
Cells housing Formulas that return "" (blank) to be excluded from
calculations
Below is a link to a similar past Thread
http://www.officekb.com/Uwe/Forum.a...-cells-in-Multiple#[email protected]
Would appreciate a Formula that can incorporate the Dynamic Named Range
"Results".
Thanks
Sam