+ Reply to Thread
Results 1 to 2 of 2

Min witout counting #DIV/0!

  1. #1
    Registered User
    Join Date
    03-21-2005
    Posts
    31

    Min witout counting #DIV/0!

    How can I get the minimun if I have a #DIV/0!

    EX.

    A
    6.5
    12.8
    #DIV/0!
    7.9
    #DIV/0!
    4.8
    = Minimun

    Thanks for helping

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996
    This formula worked for me:

    =MIN(IF(ISERROR(A1:A7),999999999,A1:A7))
    Note: You need to commit that array formula by holding down [Ctrl][Shift] when you press enter.

    (the 999999999 can be replaced with any large value that won't be the smallest in your list.)

    I hope that gets you on the right track.

    Regards,
    Ron

+ 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