Glad I was able to help Sunny
Hi Mel Your formulas in column D and E is not correct. When there are two Andy you will get the wrong answer (E6 and E8). I have included the co...
Hi Irving You could try using a cell to extract the grand total from the Pivot Table eg MAX(B4:B100) and then create a normal chart from it. Hop...
Hi Mel Just wrap your formula with =IFERROR(Your formula,0).This will display a 0 if the formula evaluates to an error. Example =IFERROR(INDEX('...
Hi Hooi Thin Normally dynamic range name is used for data table and not Pivot Table. In your situation I would prefer covering a range that is m...
Hi Amy If I have to sort that many columns (1st-6th sort), I would consider using a helper column. For example, in column AC (cell AC8) I would ...
Hi Gary Glad I was able to help. Cheers Sunny
Hi Gary Just in case you are having issues, I have attached a completed one for you. Cheers Sunny
Just change the following conditional formatting rule in bold to your required ranges. =AND($BK$30="Not Started",(I$4+J$4+K$4)<=$F$30) =AND($...
Hi Gary Copy one of the conditional formatting rows and paste it to where you want and then change the conditional formatting ranges as needed. ...
Hi Gary I have some suggestions. I have done some for you to take a look. The formula for the CF you wanted is quite long but workable. All is b...
Hi Gary I think the progress bar is possible if you update the Status in column G. You can then do a count of Completed against the total Task assi...
Hi Gary Can you provide the expected result in your attachment (what colours are expected to be seen in row 6) based on the data in the PDF?