Last seen: Apr 29, 2025
@v-r_tayloryahoo-com I looked at the file but don't understand what the problem is. could you please elaborate?
You may use SUM as usual, but must custom format the cell as [hh]:mm The square bracket turn clock-time into a duration of 101:35. Omitting this ste...
@ingaiyoung Great that you resolved it yourself, though I would still like to share two other solutions. The first considerable boosts performanc...
Difficult to judge if there is "a better way" without seeing the file. Though, in general, one should avoid using entire-column references like D:D, A...
@lukas-2 Normally, I wouldn't mind to work with helper columns. Just to see matters clear and manageable. But, of course, nowadays we have many new...
Thanks @philipt for retrieving the file! Now, @drm307, please explain a bit more what you are trying to achieve. I see a file with 23 colourful shee...
Not sure why you can't attach a file. May I assume that you pressed "Attach Files" and followed all instructions? Otherwise, save your file to OneDriv...
@bogatyrs Let me know how it goes. And... mmmm, I'm still your junior be some 17 years. 🙂
@bogatyrs So you are about my age 🙂 I started on SuperCalc in the early 80-ies of the previous century. Right-click on the Y-axis, then Format A...
Your file didn't show, though I suspect that the issues arises from both MATCH functions in the formula. The first MATCH should return a row index fro...
@lukas-2 I've changed your set-up a bit. You'll note that you can't use XMATCH (or MATCH) and an exact match if your color column has multiple color...
That doesn't sound like 'normal' behaviour. But it's difficult to assess the cause without seeing your file and knowing what Excel version you are on ...
1) Rather then modifying the working formulas in place, I would just hide the columns for Saturday and Sunday. 2) Not sure what you mean but I have ...
I believe the attached file contains a working PQ solution. It's not very fancy but it does the job. A number of custom columns that pick-up the corre...
Please upload the file shown in the picture. Then we don't have to recreate your scenario from scratch.