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

Domenic wrote:
Make sure that your numbers are actually numerical values. Try the
following...

1) Select an empty cell

2) Edit Copy

3) Select your range of numbers

4) Edit Paste Special Add Ok

Does this help?

Hi Domenic,

[quoted text clipped - 3 lines]
Thanks
Sam


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