When you work with real dates, Excel's built-in date intelligence spaces out dates on a time-line, giving you dates on the X-axis with no data points. That is true for both Windows and Mac. If you don't want that you need to work with text labels that look like dates as sho...
=IF(SUMIFS($F$2:$F$42,$B$2:$B$42,"Tuesday")>0,AVERAGEIFS($F$2:$F$42,$B$2:$B$42,"Tuesday",$F$2:$F$42,">0"),"-") (Additional spaces included for readability.)
Unlike other service providers that might excel in only a few areas, ABM delivers expertise across the board, including sanitation, production support and energy solutions. We've been servicing these specialized industries for over 50 years, that's why manufacturers and distributors can count on ABM...
John_FletcherNot sure which solutions you found for Windows. When you work with real dates, Excel's built-in date intelligence spaces out dates on a time-line, giving you dates on the X-axis with no data points. That is true for both Windows and Mac. If you don't want...