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.
This formula is under column G on the trending tab.Please Login or Register to view this content.
Bookmarks