View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Blobbies
 
Posts: n/a
Default 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