Try...

=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.

Hope this helps!

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

Hi Domenic,

Thanks for reply and ongoing help. Formula provides correct result.

Can this Formula be adapted to provide results for ONLY Visible Filtered
cells.

=MODE(IF(B1:J10="North",A1:I10))

...confirmed with CONTROL+SHIFT+ENTER.

Thanks
Sam