×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

MAX MIN Surprise Excel 2007
3

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.
 

View Clyde's profile on LinkedIn

RE: MAX MIN Surprise Excel 2007

2
The limit applies to the number of separate arguments passed to the function, so if your numbers are contiguous, that only counts as a single argument.  

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

(OP)
Thanks IRstuff.  I see that I have used a commma (,) instead of a colon (:) so I was not describing a RANGE.

A single conversation with a wise man is better than ten years of study.  ~Chinese Proverbsmile

View Clyde's profile on LinkedIn

RE: MAX MIN Surprise Excel 2007

FYI for anyone else interested, the number of parameters allowed for MAX was changed in either 2003 or 2007, i.e., Excel2002 still has only 30 arguments allowed.

TTFN

FAQ731-376: Eng-Tips.com Forum Policies

RE: MAX MIN Surprise Excel 2007

Thanks to both of you.  I like the threads where people identify unexpected behavior. Everyone benefits.

=====================================
Eng-tips forums: The best place on the web for engineering discussions.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources