| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pin a callout data point | Charts and Charting in Excel | |||
| Point Assessment Calc? | Excel Discussion (Misc queries) | |||
| Scatter Chart Data Point Highlighting | Charts and Charting in Excel | |||
| Display a digit before or after the decimal point in another cell | Excel Worksheet Functions | |||
| decimal point override does not work | Excel Discussion (Misc queries) | |||
Threaded Mode
