# Search results

1. ### Get workdays in a month

Thanks for the help vletm.
2. ### Get workdays in a month

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...
3. ### Get workdays in a month

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...
4. ### Sumifs based on short date format

Thanks a lot guys for your support. I am waiting a bit. Maybe someone has another formula solution.
5. ### Sumifs based on short date format

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...
6. ### Sumifs in merged cells with criteria

Thank you guys!
7. ### Sumifs in merged cells with criteria

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...
8. ### Project duration chart with timeline

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...
9. ### increment value in same colmun using loop

another Sub sample() Worksheets("Sheet1").Range("A3:A10").Formula = "=A2*1.06" End Sub
10. ### find first non-blank text cell based on multiple criteria (w/o array)

Thank you, it works well.
11. ### find first non-blank text cell based on multiple criteria (w/o array)

Hi GraH - Guido, I checked your formula but doesn't work on my side.
12. ### find first non-blank text cell based on multiple criteria (w/o array)

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...
13. ### Font size modification (excel range to powerpoint)

Yes, I can change it manually from PowerPoint (but I would like to avoid the manual steps if possible).
14. ### Font size modification (excel range to powerpoint)

Anyhow, thank you for your time and effort! Does anybody have any idea?
15. ### Font size modification (excel range to powerpoint)

No change. The font size of the Table on ppt slide is the same than before.
16. ### Font size modification (excel range to powerpoint)

I tried in various way but I cannot change the font size of myShapeRange object. Please, see the attached file.
17. ### Font size modification (excel range to powerpoint)

I have Run-time error 438 at this line. Object doesn't support this property or method.
18. ### Font size modification (excel range to powerpoint)

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...
19. ### Bar chart problem

Ok, I try to figure out.
20. ### Bar chart problem

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.
21. ### Bar chart problem

Now I see, thank you the help!
22. ### Bar chart problem

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

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).
24. ### Bar chart problem

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!
25. ### VBA to insert formula in column

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 = _...