Last seen: Apr 27, 2025
@shina-christmartanti Please elaborate. What exactly are you trying to achieve and what doesn't work? Can you share a file with the query(ies) that ...
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.