Last seen: Jun 4, 2025
No file was attached. Please try again and don't forget to press "Start upload" and wait for it to finish before you submit your reply.
I couldn't test the formula as I received a #CONNECT! error, but I believe you want to sort a transposed list by dates in columns in descending order....
The screenshot didn't come through. Save it to your computer first, then upload it as an attachment and press 'start upload', wait until it's finished...
Oh, but that makes it much more complicated with pictures, that is. I wish you hadn't simplified your example so much. Since you rarely get the correc...
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!!