Hi Domenic,

Thank you for all your help and perseverance - greatly appreciated.

I've chosen this version of the Formula - works great:
=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.

Apologies once again for not providing the complete picture previously.

Cheers
Sam

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. An alternative would be to use
your column headers/labels to decide which columns you want to include
in the evaluation...

=MODE(IF(SUBTOTAL(3,OFFSET(A2:AM10,ROW(A2:AM10)-MIN(ROW(A2:AM10)),0,1)),I
F((ISNUMBER(MATCH(A1:AM1,{"Header1","Header2","He ader3"},0)))*(ISNUMBER(A
2:AM10)),A2:AM10)))

...where Header1, Header2, and Header3 represent the column heading for
the columns you want included in the evaluation. Replace these with
your actual column headings and add to them as needed.

or

=MODE(IF(SUBTOTAL(3,OFFSET(A2:AM10,ROW(A2:AM10)-MIN(ROW(A2:AM10)),0,1)),I
F((ISNUMBER(MATCH(A1:AM1,A15:A17,0)))*(ISNUMBER(A 2:AM10)),A2:AM10)))

...where A15:A17 contains a list of column headers indicating the
columns you want included in the evaluation.

Hope this helps!

Hi Domenic,

[quoted text clipped - 21 lines]
Thanks
Sam


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