+ Reply to Thread
Results 1 to 6 of 6

Broken Min/Max function

  1. #1
    Registered User
    Join Date
    10-10-2010
    Location
    Timbuktu
    MS-Off Ver
    Excel 2003
    Posts
    8

    Broken Min/Max function

    I have a simple series of 85 values. At the bottom, I ask Excel to return the MIN & MAX.
    It finds the wrong values (as I indicate in the attached).

    It appears to be selecting the first and last elements in the array.

    What's up w/ that?
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,607

    Re: Broken Min/Max function

    What do they call someone who blames their tools...?

    Try replacing the comma with a colon.

  3. #3
    Registered User
    Join Date
    10-10-2010
    Location
    Timbuktu
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Broken Min/Max function

    Thanks Stephen R. I guess the real question is:

    Why did Bill Gates post this as the proper syntax in MIN/MAX help:

    MIN(number1,number2,...)
    MAX(number1,number2,...)


    for Excel 2003?

    Go figure ...

    Colon it is...

  4. #4
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,607

    Re: Broken Min/Max function

    That is the proper syntax. You should have written MIN(A1,A2,A3 etc) or more simply (A1:A85). This one cannot be pinned on Bill Gates.

  5. #5
    Registered User
    Join Date
    10-10-2010
    Location
    Timbuktu
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Broken Min/Max function

    I realized the error in my logic even before you posted back, SR. You're right. The colon is used to effect the series; I was pointing to the ends of the array. I got what I asked for. My bad.

    And yes, the online help (syntax) was right.

    I have many other things to pin on BG, but not this one.

    Thanks again.

  6. #6
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,607

    Re: Broken Min/Max function

    My pleasure.

    The battle continues...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1