Last seen: Jun 13, 2025
@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.
@mrm See attached!
@Mrm Not sure either what your intentions are but if you want the slicer to control both pivot table based on the 'Resource', then you must use the ...
Can you share your file? It's difficult to help based and your description of the problem only.
Oh, but then you should your approach. No need for the intermediate EXTRACT table, provided you are using a modern Excel version, using CHOOSECOLS and...
What do you have in mind? Change something in the EXTRACT table or add a row with relevant data and the scrollable view updates automatically. Am I mi...
Not 100% what you asked for but it could be acceptable for you anyway. The following M-code produces a table that resembles your FINAL sheet. Just poi...
Change the CHOOSE part of the formula to CHOOSE(OrderBy,1,-1) and it shall work.
Please share your file (press the paper clip icon "Attach Files" below the editor where you write your reply) as it's not clear from your question alo...
Still not clear to me. Sorry! Do you really set limits up to 56 hours on a weekly running total basis. For instance, employee 1 worked 2102 hours in 2...
It seems that when an employee works, for example, three full weeks of 40 hours for a total of 120, they only get 3 hours leave. Even though 120 equal...