Hi Blanka I too am unable to replicate your result. I am getting the same result as Velouria. 1st time there is a number, 2nd time is 0. Can'...
Hi Suzanne The error is from your file. Not from the formulas. Column F is linked to 'C:UsersThe Girls 2Google Drive3StormbornClinical Documents...
Here is another method using Pivot Tables. I have tided up some invalid dates (29/2/2017) in your data. Sunny
Hi Suzanne I would suggest you add 2 helper columns. One for Year and another for Month. You can then use the SUMIFS and COUNTIFS to sum/count w...
Maybe you can also try a 2-tone color?
Hi lea If you set up a 3rd condition (like what Velouria suggested) then you will need to take into account which condition takes precedent first. ...
Hi lea Just enter an asterisk (*) into cell N3 Sunny
Hi Karthi You can key the full path into a cell and then refer to it via the macro. Eg. enter the full path in cell D1 like h:desktop then in...
Hi Blanka Try this Sub ClearEmptyCells1() ' Processes an entire worksheet ' Targets all cells containing constants and text ' If those cells con...
No problem. Glad I was able to help. Sunny
A 3rd method, copy the chart and paste link image. Now set the chart fill color to transparent (PictureTools-Format-Color-Set Transparent Color) ...
Here is another try. 1) Create 2 similar area charts with different color (red and green) 2) Fix the axis max and min value (to prevent the char...
Hi Philip Please refer attachment. Sunny
Hi Matthew Sorry if I am not clear about your needs. It would be better if you could attach an image of how you wanted the chart to look like (w...
Looks like Mynda have beaten me to the answer Yes, use Conditional Formatting. If your PT is in a Tabular format, you can easily use a formula to ...