Search results

Thanks for the help vletm.

Hi vletm, Thanks for taking the time to help me. Have a look at the answers here. Q1 : In this example, the correct formula (see the expected result in cell N9) should give 23.04167 days (= total of 554 working hours / 24 hours) in December 2023. Q2 : The 3rd shift is 8 hours long, no work on...

Hi there, I am trying to calculate the workdays in a month according to a unique shift model, but I am stuck. The summary: The hours for each shift are spread over a 6-day workweek that runs from Monday through Saturday. Bank holidays must be taken into account. The 1st shift is 8 hours long...

Thanks a lot guys for your support. I am waiting a bit. Maybe someone has another formula solution.

Hi everyone, I would like to ask you to support me. The problem : how to "sumifs" the sales view based on "Customer" and "Calendar Month Historical" but the "Calendar Month Relevant" needs to be smaller or equal to the Calendar Month Historical. The tricky part is that, I can only retrieve...

Thank you guys!

Hello, I would have a question regarding the "sumifs" of merged cells, it is inspired by a formula challenge in 2013. Here is the path to the thread: https://chandoo.org/forum/threads/formula-challenge-021-sumif-in-merged-cells.11927/ The question: how to sum the values with criteria? The...

Hello, Could you please give me support to create a bar chart regarding project milestones visualisation? My problems are: 1. the start and end dates of project milestones are stored as weekweek.yearyearyearyear 2. the duration of project milestone with start and end week have to be presented...

another Sub sample() Worksheets("Sheet1").Range("A3:A10").Formula = "=A2*1.06" End Sub

Thank you, it works well.

Hi GraH - Guido, I checked your formula but doesn't work on my side.

Hello, I would need your support to find the first non-blank text cell based on multiple criteria but without array formula. The original file has more 10.000 rows and the calculation time of my array formula takes long time. Please, see the details and expected result in the sample file. Do...

Yes, I can change it manually from PowerPoint (but I would like to avoid the manual steps if possible).

Anyhow, thank you for your time and effort! Does anybody have any idea?

No change. The font size of the Table on ppt slide is the same than before.

I tried in various way but I cannot change the font size of myShapeRange object. Please, see the attached file.

I have Run-time error 438 at this line. Object doesn't support this property or method.

Hello, I would like to ask some advice regarding font size modification (in Excel 2013 or above), because I do not find the correct way and I am lost. The below mentioned code copy the Excel range then paste it in powerpoint but unfortunately I cannot change the font size (6 to 8) of...

Ok, I try to figure out.

Hello @Hui, I would like to continue this thread and ask your advice again. How would be possibe to create the same chart if the dates of Project Issues are not in ascending order? Please, see the attached file.

Now I see, thank you the help!

No, I manually added the shapes what I would like to see on the chart. Please, see that.

Hello Hui, Thank you, your sample file is very close to my target. One thing is missing: I would like to see the "Start" and "Closing" date of each project on the chart in order to understand easier the duration (a simple black line around the bar would be enough).

Hello, I would need your support regarding bar chart creation. The details and expected results are in the attached file. Thank you in advance any feedback!

Hi, This code in the ThisWorkbook put the required formulas on sheet LAB (column N, AC, AR and BG) when you open the file and enable the content. Not update more columns. Option Explicit Private Sub Workbook_Open() Worksheets("LAB").Range("N3:N102").FormulaR1C1 = _...