MAX MIN Surprise Excel 2007
MAX MIN Surprise Excel 2007
(OP)
At least a surprise to me. . .
While trying to determine the maximum and the minimum for a column of numbers of almost 3000 points, I discovered that the =MAX() and =MIN() statements have a limit of 255. I never paid attention to the note in the description of the function.
To get the Max and Min for the column see attached spread sheet (MAX MIN.xlsx)
If the cells are in a contiguous row or column
1. Select a cell below or to the right of the numbers for which you want to find the smallest number.
2. On the Home tab, in the Editing group, click the arrow next to AutoSum, click Min (calculates the smallest) or Max (calculates the largest), and then press ENTER.
While trying to determine the maximum and the minimum for a column of numbers of almost 3000 points, I discovered that the =MAX() and =MIN() statements have a limit of 255. I never paid attention to the note in the description of the function.
To get the Max and Min for the column see attached spread sheet (MAX MIN.xlsx)
If the cells are in a contiguous row or column
1. Select a cell below or to the right of the numbers for which you want to find the smallest number.
2. On the Home tab, in the Editing group, click the arrow next to AutoSum, click Min (calculates the smallest) or Max (calculates the largest), and then press ENTER.





RE: MAX MIN Surprise Excel 2007
Note that this is an improvement over Excel2000, which only allowed 30 arguments for the same function.
Unless they changed some other logic, your example is not correctly inputted as a RANGE, i.e., A1:A2942. Note that the maximum of your column is actually 0.093551833. The Number2 field is for a non-contiguous data input, not the end of the contiguous range.
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: MAX MIN Surprise Excel 2007
A single conversation with a wise man is better than ten years of study. ~Chinese Proverb
RE: MAX MIN Surprise Excel 2007
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: MAX MIN Surprise Excel 2007
=====================================
Eng-tips forums: The best place on the web for engineering discussions.