Hi Aladin,

Thank you for your added assistance with the Formula and helpful comments
regarding the Formula structure.

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

Aladin Akyurek wrote:

It's not unsafe to reduce

-MIN(ROW(F2:AL10))

to just

-ROW(F2)

Aladin Akyurek wrote:
It always adds to efficieny. And the idiom still stays Longre's.

It's not unsafe to reduce

[quoted text clipped - 9 lines]
increase in efficiency negligible, though? I tend to prefer Longre's
idiom...

Thanks
Sam


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