Hi Matt Have you tried clicking the negative (-) button to the left of the headers? It will collapse the entire field group leaving only the sub...
Hi Jay Glad that we could help. Learning Excel is definitely a good investment as the skills are very useful for your career. Even if you use...
Hi Jay Try this formula: =IF(OR([@[% Complete]]="",[@[Due Date ]]<[@[Start Date ]]),-1,IF([@[% Complete]]="Ongoing",0,IF([@[% Complete]]=1,1,...
Hi Maurizio Could you post the full code as the code you have given is insufficient to test. Sunny
Hi Katrina I am not familiar with PQ but from your Capture.png it might be the date format problem, 31-10-2018 instead of 31/10/2018. From Captu...
Hi Jay Bee From your attachment, I noticed that the Conditional Formatting (CF) in column H is inconsistent. I also noted that you have custom f...
Hi Maurizio See attached. It will add today's date above any cell that you enter data in column B. Hope your daughter like it. Sunny
=(K18>J18)*1 will also work
If you can add a helper column like what Paul suggested, that would be the best as it avoids all the complications of an ARRAY formula. My formula ...
If I am not mistaken, INDIRECT does not work with a closed workbook. The source workbook must be open for it to calculate and the INDIRECT formula ...
Hi Sari Glad to know the formula is working for you. Let me try to explain the formula in detail: =IF(B3<>B2,"D"&RIGHT(A2,6)+1,A2) ...
Hi Maurizio Please refer attached. I have disabled your ON ERROR RESUME NEXT that ignores error (should be avoided). Hope this helps. Sunn...
Hi Melissa In cell B2 enter =SUM(IF($K$18:$K$722>$J$18:$J$722,IF($G$18:$G$722=A2,1,0),0)) This is an array formula so you will need to pre...
Hi Sari Refer attached for a formula solution. Hope this helps. Sunny
Hi Elinor You already have a Grand Total in column V so why are you summing the row again? If you need to find any shop total , you can use the ...