Last seen: Jul 6, 2026
Inte just nu. Sorry!
@leif-norindergmail-com Hej Leif, I'm a bit short on inspiration right now, but perhaps you can accept a solution with a few helper columns. See ...
@leif-norindergmail-com Not really. What's the logic for 2, 0, 1 etc.?
@leif-norindergmail-com Can you please upload a file with some example data and the expected outcome. Than we don't have to second guess and provide...
First I would like to suggest that you switch off CAPS-LOCK when you writes questions/comments like these. It’s more pleasant to read regular texts :)...
@vipul-jhaveri You need to share your file. Otherwise it's difficult to help. Though, remove any private and confidential information before doing so.
@blankab Thanks for sharing! I never thought about that one.
@metalformerp56 What if you use Power Query to split the long text into rows, first by ")" and then by the first 6 spaces. It results in something lik...
Sure! Send it to the following address: kpmnhlmn at duck dot com
The template works from an accounting point of view. Debit = expense and Credit = Income, and 'under the hood', Power Query turn all the debits to neg...
Okay, PQ isn't difficult to learn but it takes some effort to get started. Consider taking some of the courses offered on this site. In PQ you can g...
My assumption is that you want to identify the discrepancies between the Accounting and Bank columns. There are many duplicate numbers so it's not pos...
That's difficult to diagnose based on one picture alone. Could you perhaps share an example file with the query that doesn't give the desired result? ...
Sorry, but VBA is definitely not my thing. Perhaps someone else.
@prof_fr Much improved, though I couldn't resist helping out a bit more. In the attached file I cleaned up the invalid/incorrect named ranges and a...