Hi Domenic,

Yes, there are some blank cells at the end. I've tried the Formula below but
I now get a much lower value than I should.

Thanks
Sam

Domenic wrote:
Actually, MODE ignores text values, so that shouldn't be an issue. Does
your table contain blank cells? If so, try the following formula
instead...

=MODE(IF(SUBTOTAL(3,OFFSET(A1:J10,ROW(A1:J10)-MIN(ROW(A1:J10)),0,1))*(A1:
J10<""),A1:J10))
...confirmed with CONTROL+SHIFT+ENTER. Does this help?


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200507/1