Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Mar 2003
    Posts
    174
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Max / Min with error cells (Excel 2000)

    Is there an easy way to get around error cells when using MIN or MAX functions ? Seems it there is an error cell in the list, the function would not work.

  2. #2
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Max / Min with error cells (Excel 2000)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> TQ2

    Alas the Search function is turned off temporarily, but I do remember a thread asking how to get the largest cell value in a range, maybe with some tweeking you can bypass the Max and Min functions.

    Try VBA for now, if you need help post a reply, and I'll try and dig out this thread and see if you can do some teewking and get what you want.

    Stand By, this may take a while...

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  3. #3
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Max / Min with error cells (Excel 2000)

    Hi TQ2,

    The following array-enertered formula works for A1:A10:
    =MIN(IF(ISERROR(A1:A10),"",A1:A10))
    Just change the range to suit your needs. To array enter, type the formula, then press Ctrl-Shift-Enter. If you forget this last step, just re-select the cell and press Ctrl-Shift-Enter to convert the ordinary formula to its array version.

    Cheers
    Cheers,

    Paul Edstein
    [MS MVP - Word]

Posting Permissions

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