+ Reply to Thread
Results 1 to 2 of 2

How to find Top 10/Lowest 10 values based on Month 2nd

  1. #1
    Forum Contributor
    Join Date
    11-27-2009
    Location
    Austin, Texas
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    409

    How to find Top 10/Lowest 10 values based on Month 2nd

    Thanks to User MySore, I was able to obtain the solution to my issue with my project, now I need help with pretty much the same formula as I have discovered a problem.
    Here is a link to the previous question: http://www.excelforum.com/search.php?searchid=3057351

    I have included an attachment of the results from the previous post, everything is working as it should.
    I am now finding, if I have a few zero values as showing on Fleet Volume-Color for example under Dec, it appears to be show blank rows on the Trending tab down at rows 30 to 41 under column G. Its ok to show the first found zero value but I want to exclude the other zero values found on the fleet volume-color monthly columns.

    I need help with the formula on the trending tab to exclude zero values.

    Please Login or Register  to view this content.
    This formula is under column G on the trending tab.
    Attached Files Attached Files
    ==========
    Bigroo1958
    Austin, Texas
    ==========

  2. #2
    Forum Contributor
    Join Date
    11-27-2009
    Location
    Austin, Texas
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    409

    Re: How to find Top 10/Lowest 10 values based on Month 2nd

    Bumping this!

+ 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. [SOLVED] How to find Top 10/Lowest 10 values based on Month
    By bigroo1958 in forum Excel General
    Replies: 4
    Last Post: 06-19-2014, 06:30 AM
  2. Replies: 1
    Last Post: 01-10-2014, 01:55 PM
  3. Find the average of the lowest four values of the last six
    By pjmcc64 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-03-2010, 06:26 PM
  4. [SOLVED] How do I find the two lowest values in a range?
    By dlroelike in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-20-2005, 09:06 PM
  5. Find the 40 lowest values within a selection
    By Grotifant in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-08-2005, 12:48 PM

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