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

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

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