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

Domenic wrote:
Try...

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

...confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!

Hi All,

[quoted text clipped - 55 lines]
the right, in this case Column D, and so on. Also, adjust the range
accordingly.


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