Last seen: May 1, 2025
COUNTIFS works like multiple AND functions. One you your (single cell) criteria ranges contains a 0 and another a 1. Therefore, the result is 0. Only ...
@leno Nu fick jag lite inspiration. Titta om det funkar för dig.
@shina-christmartanti Can't really tell why that happens. Occasionally (quite rare), Power Pivot 'hangs up' itself for me, and then I can't use the ...
@lizch Can you please show us an example of your data and the formula used for the calculated field?
@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...