Domenic wrote:
Hi Sam!

Let's adopt Aladin's formula...

=MODE(IF(SUBTOTAL(3,OFFSET(F2:AL10,ROW(F2:AL10)-MIN(ROW(F2:AL10)),0,1)),I
F((MOD(COLUMN(F2:AL10)-COLUMN(F2)+0,8)=0)*(ISNUMBER(F2:AL10)),F2:AL10)))

...confirmed with CONTROL+SHIFT+ENTER.

[...]

It's not unsafe to reduce

-MIN(ROW(F2:AL10))

to just

-ROW(F2)

though.