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","Hea der3"},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(A2 :AM10)),A2:AM10)))

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

Hope this helps!

In article ,
"Sam via OfficeKB.com" wrote:

Hi Domenic,

Tested numbers and they are numerical.

Apologies for this ongoing Post: I've just realised my error in that I'm not
getting the correct MODE value because I've included columns with numerical
values that need to be excluded when calculating the MODE value. The columns
that I need the overall calculated MODE value for are columns F, N, V, AD and
AL using the feature of Filtered Visible cells.

My columns with data start from column A - AM and comprise the following:

Numerical data TO BE INCLUDED in MODE calculation = Columns F, N, V, AD, AL

Numerical data EXCLUDED in Mode calculation = Columns A, B, C, D, E, I, J, K,
L, M, Q, R, S, T, U, Y, Z, AA, AB, AC, AG, AH, AI, AJ, AK

Text Data = Columns G,O, W, AE, AM

Empty Columns = Columns H, P, X, AF, AN

I apologise for my confusion.

Thanks
Sam