Forum

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.

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