In article ,
"Sam via OfficeKB.com" wrote:
Dynamic Name "Results" is Defined as Refers To =OFFSET(History!$A$18,1,0,
COUNT(History!$A:$A),15)
Dynamic Range "Results" needs to be Offset one column to the right,
calculations will include columns 2-15.
Insert Name Define
Name: Results2
Refers to:
=OFFSET(Results,0,1,,14)
I require a Formula to produce the Arithmetical MODE for numerical values
taking into account the following:
Working with Auto-Filtered data so calculations need to display results for
Visible Filtered Cells.
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.as...thmetical-Mode
-Value-for-Filtered-cells-in-Multiple#5183599F654B4%40OfficeKB.com
Would appreciate a Formula that can incorporate the Dynamic Named Range
"Results".
=MODE(IF(SUBTOTAL(3,OFFSET(Results2,ROW(Results2)-MIN(ROW(Results2)),0,1)
),IF((MOD(COLUMN(Results2)-MIN(COLUMN(Results2))+0,8)=0)*(ISNUMBER(Result
s2)),Results2)))
....confirmed with CONTROL+SHIFT+ENTER.
Hope this helps!