• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Recent content by Villalobos

  1. V

    Get workdays in a month

    Thanks for the help vletm.
  2. V

    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. V

    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. V

    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. V

    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. V

    Sumifs in merged cells with criteria

    Thank you guys!
  7. V

    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. V

    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. V

    increment value in same colmun using loop

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

    find first non-blank text cell based on multiple criteria (w/o array)

    Thank you, it works well.
  11. V

    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. V

    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. V

    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. V

    Font size modification (excel range to powerpoint)

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

    Font size modification (excel range to powerpoint)

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