Last seen: Apr 30, 2025
I'm not a Python person, but by looking at your desired end result (the yellow area) I believe I understand what you are needing. I connected to th...
You should probably use one of Excel's lookup functions (LOOKUP, VLOOKUP, XLOOKUP, INDEX/MATCH). There are plenty to choose from. Please add some cont...
You see, I didn't even understand you solved the problem 🙂
Needed to reply to the lastest post in order to moderate it. Unfortunately, I'm in no position to help you with VBA 🙂
Not sure I understand what exactly you are looking for, but perhaps that the PT in the attached file is a start. If not, please specify what "max conc...
Maybe, but I still don't understand. If 'Yes' would become 1 and 'No' would be 2, 3 yes and 2 no would average to (1+1+1+2+2) / 5 = 1.4. But does tha...
I created an area with formulas (I30:O41) that do what I think you need. But please check, since my numbers don't match the ones you entered manually....
Please upload your file (not a screenshot). I will be much easier to help that way.
Go to 'Pivot Table Options' and make sure that the 'Retain items deleted .......' switch is set to None. That should fix it.
No I don't know what's correct, but remember the guy from the video mentioning that the +1 was needed because he wanted to include the start date in t...
Glad it works then. Regarding the "better way", just follow the YT-video you included in your first post. It explains a much easier approach.
In this case I would add an "index" column containing sequential numbers starting at one. These will be the row numbers for each part of the trip. The...
Why did you choose to go the complicated way with List.Generate, creating tables and then merging them? The approach in the video is much simpler. But...
You mention working days and that the file contains projects without an end date. However, the file seems to be set up to calculate working hours and ...
What I meant is that you need to explain how you would calculate such an average.