+ Reply to Thread
Results 1 to 2 of 2

Find minimum in range that has blanks and zeros

Hybrid View

  1. 04-21-2005, 05:27 PM #1
    supermario77
    supermario77 is offline
    Registered User
    Join Date
    04-21-2005
    Posts
    14

    Find minimum in range that has blanks and zeros

    Hi
    I have a range a2:a33 that contains blanks and zeros.
    I want to find the minimum value greater than 0

    The formula
    =min(a2:a33) returns 0

    thanks
    Reply With QuoteRegister To Reply
  2. 04-21-2005, 06:19 PM #2
    BenjieLop
    BenjieLop is offline
    Forum Contributor
    Join Date
    06-23-2004
    Location
    Houston, TX
    Posts
    571
    Quote Originally Posted by supermario77
    Hi
    I have a range a2:a33 that contains blanks and zeros.
    I want to find the minimum value greater than 0

    The formula
    =min(a2:a33) returns 0

    thanks
    Here is your formula ...

    =small(A2:A33,countif(A2:A33,0)+1)

    Regards.
    BenjieLop
    Houston, TX
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1