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.as...40OfficeKB.com


Would appreciate a Formula that can incorporate the Dynamic Named Range
"Results".


Thanks
Sam


--
Message posted via http://www.officekb.com