Hi Michael Thanks for your feedback. I did not say that there is no practical use in counting/summing cells with colors but there are some restric...
Not too sure if a custom number format using “▲”; “▼”; will work on the chart labels (values) in your situation.
In cell B1 enter : =IF(C1="Cancelled","False",IF(COUNTIFS(A1:$A$13,A1,C1:$C$13,""&"Cancelled")=1,"True","False"))
Hi Josh Give this a try. It randomly distribute a fixed value across a range. Hope this is what you are looking for. Sunny
I have Excel 2019 and don't have this issue. Is your copy a trial version?
Hi Lea I did not encounter any problem. I was able to add a new row with the TAB key. Possible your Excel setting issue?
My suggestion for the "Absent" is : (1) Let the status be "Late" even on the third "Late" (2) In cell C50 (under the deduction calculation) coun...
Hi Mynda You are correct. If one of the axis is deleted it will follow the scale of the other axis (common scale). In this case I deleted the se...
Hi Mynda The total revenue column (740) is lower than the total overhead (795) on my chart. Am I missing something? Sunny
Hi Steve I managed to create the Pivot Chart and included a Slicer as well (using Excel 2019). Please note that I have to use a dummy series (us...
Another solution =SUMIFS(D:D,A:A,">="&I3,A:A,"<="&I4)
There is no attachment
Another reason for the #N/A could be the displayed value and the actual value is different. For example, the cell is formatted to display 333 but t...
Hi Steve Frankly I can't recall how I created this chart 5 years ago (sign of old age I guess) I was able to recreate the chart via a Pivot Tabl...
Hi Lea Select the entire sheet. Right-click any cell. Select Format Cells - Protection and tick Hidden Protect the sheet. All formulas ...