MAX, MAXA - Driving me to the point of distraction!!!
 

i have a range of numbers.

it includes a number of 0's (zeros), 1's, 2's, 3's etc.

i have asked excel to give me the highest number in the range - (have tried:
=LARGE(E4:E105,1), =max(E4:E105) and =maxa(E4:E105)

it keeps giving me 2 as the highest number, when i can quite plainly see
that 3 is the highest number ......

i know this will be something dumb that i'm doing, but doesn't stop me being
driven crazy along the way ...

thanks for your help!



mike

MAX, MAXA - Driving me to the point of distraction!!!
 

All of those formulas should work. So, a couple things I'd check.

Are Automatic Calculations turned on? TOOLS--OPTIONS--CALCULATION
Tab--Check "Automatic"

Are the 3's entered as Text or Numbers? If Text, then that would explain
why they aren't showing up. Re-enter them as numbers or use this formula:

=MAX(VALUE(E4:E105))

Enter this as an array. Ctrl-Shift-Enter.

HTH,
Elkar


"Blobbies" wrote:

i have a range of numbers.

it includes a number of 0's (zeros), 1's, 2's, 3's etc.

i have asked excel to give me the highest number in the range - (have tried:
=LARGE(E4:E105,1), =max(E4:E105) and =maxa(E4:E105)

it keeps giving me 2 as the highest number, when i can quite plainly see
that 3 is the highest number ......

i know this will be something dumb that i'm doing, but doesn't stop me being
driven crazy along the way ...

thanks for your help!



mike

MAX, MAXA - Driving me to the point of distraction!!!
 

thanks for that elkar

your array formula was perfect!

i changed the format to numbers, but that didn't work - possibly because i
have got the calculation on automatic, although i did F9 the sheet! it takes
too long for my old clunker of a computer to calculate automatically!!

cheers!!



"Elkar" wrote:

All of those formulas should work. So, a couple things I'd check.

Are Automatic Calculations turned on? TOOLS--OPTIONS--CALCULATION
Tab--Check "Automatic"

Are the 3's entered as Text or Numbers? If Text, then that would explain
why they aren't showing up. Re-enter them as numbers or use this formula:

=MAX(VALUE(E4:E105))

Enter this as an array. Ctrl-Shift-Enter.

HTH,
Elkar


"Blobbies" wrote:

i have a range of numbers.

it includes a number of 0's (zeros), 1's, 2's, 3's etc.

i have asked excel to give me the highest number in the range - (have tried:
=LARGE(E4:E105,1), =max(E4:E105) and =maxa(E4:E105)

it keeps giving me 2 as the highest number, when i can quite plainly see
that 3 is the highest number ......

i know this will be something dumb that i'm doing, but doesn't stop me being
driven crazy along the way ...

thanks for your help!



mike