Last seen: Jul 7, 2026
You can write a formula that looks up the Payee from the transactions list in the list of companies with zero VAT. If found, then apply 0%, otherwise ...
Understood. Then perhaps the attached file contains a solution that provides you with a partial solution. It summarises the 'scores' Category and Sub-...
Perhaps you have over-simplified the example. Would you really want to compare Product2 of Brand C with Product1 of Brand M? How would Excel know that...
Difficult to explain but working with formulas like =B2<>B3 in a CF rule doesn't work as you might think. If you can live with alternating color...
With only two files you connect to each of them and do a merge with an Inner Join to get the 'overlapping' names. Now I'm not sure where the "weekl...
Indeed! Group by Country, All Rows. Then add a custom column where you type the M-code for a "fill down" referring to the custom column, now containin...
All you mention is that you have 'a sheet' that needs to be turned into 'a different format'. And the other system requires 'a specific format'. I...
Thanks for the file. If the texts are really as straight-forward as in your example, the easiest way would be to first extract everything before " 202...
Well, you could start by sharing some example data. Replace any confidential information, like real names, with made-up ones. You can upload a file wi...
Please elaborate and clarify what exactly you would want to extract from the example texts in your post.
Makes sense Anders! I totally misread the OP's intentions. Tack så mycket!!
I'm afraid PQ can't create a schedule like you attached to post nr 9. It's a formatted report with boarders, colors, a picture, checkboxes, data valid...
You may want to have a look first at Mynda's blog post on how to create a P&L with a regular pivot table. It's not all that complicated. Excel ...
I didn't notice your post number 6 until now. Sorry for being ignorant, but I don't know what you mean. what would you want to extract and how shou...
I didn't notice your post until today. Looked at your file but have difficulties understanding what you exactly want. You have successfully applied co...