+ Reply to Thread
Results 1 to 3 of 3

Finding Minimum Value INCLUDING 0

  1. #1
    Registered User
    Join Date
    11-05-2019
    Location
    Hawaii
    MS-Off Ver
    2013
    Posts
    3

    Finding Minimum Value INCLUDING 0

    I am trying to find an average percentage score of 6 different numbers, but I want to delete the MIN and MAX number included in the Array.

    For example This is my data set: imgur.com/a/0xvRjae
    In row 29 i put the formula: =(SUM(H29:M29)-MAX(H29:M29)-MIN(H29:M29))/100
    That came out to a value of 0.34, which is the desired number I wanted.

    But in 32 and 34, the values come out wrong (one as a negative value, which it should never go below 0). It doesn't include 0 in the formula. I want to know how to include 0 as a minimum number in the calculation.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Finding Minimum Value INCLUDING 0

    Please read the yellow banner at the top of the screen and add you excel file HERE on the excel forum, as your link is dead.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Finding Minimum Value INCLUDING 0

    That formula won't give you the average - you will need to divide by the number of cells which are contributing to the sum. Also, if you have two or more values which are maximum (or minimum), won't you want to disregard all those values?

    Pete

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Finding Minimum Value for Inventory using VBA
    By ggmkp in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-14-2019, 05:45 PM
  2. Finding Minimum Excluding the zero
    By thong127 in forum Excel General
    Replies: 18
    Last Post: 10-21-2016, 01:31 PM
  3. [SOLVED] Finding the minimum non zero value in a column using VBA
    By eocsur in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-08-2015, 04:09 AM
  4. Replies: 7
    Last Post: 04-17-2013, 03:53 PM
  5. Finding the minimum value
    By northerng in forum Excel General
    Replies: 2
    Last Post: 05-27-2011, 03:48 AM
  6. Using formulas including a maximum and a minimum
    By sura in forum Excel General
    Replies: 3
    Last Post: 05-07-2009, 09:34 AM
  7. Finding a minimum value
    By Jan Kronsell in forum Excel General
    Replies: 2
    Last Post: 03-29-2005, 07:06 AM

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