To calculate MODE for all visible filtered cells, try...

=MODE(IF(SUBTOTAL(3,OFFSET(A1:J10,ROW(A1:J10)-MIN(ROW(A1:J10)),0,1)),A1:J
10))

....confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!

In article ,
"Sam via OfficeKB.com" wrote:

Hi All,

Can you advise how I can get the overall MODE value for 5 non-adjacent
numerical columns that have been filtered on various criteria. I require the
MODE value for ONLY the Visible Filtered cells that remain - can this be made
available without specifying numerous criteria in the Formula?


The Formula below was provided by Domenic to calcuate the MODE value of a
single TEXT criterion that is located in several (5) non-adjacent columns to
show the MODE of ONLY Visible Filtered cells.

=MODE(IF((SUBTOTAL(3,OFFSET(B1:J10,ROW(B1:J10)-MIN(ROW(B1:J10)),0,1))0)*
(B1:J10="North"),A1:I10))
...confirmed with CONTROL+SHIFT+ENTER.


Thanks
Sam