Last seen: Jun 7, 2025
OK. See attached. I included your form in the file I sent earlier. See if you can get it to work.
A screenshot isn't really helpful. Especially as it doesn't include the column and row headers. Better to upload your file. When you do that, please ...
Best to create a small lookup table with the rates and 'from KM' limits. You can then use the LOOKUP function to retrieve the correct rate/allowance p...
When I open your file, the dates in columns M:X are in fact recognized as text. They all show as "yyyy-mm-dd", whereas the other (real) dates are like...
I apologise for having jumped to conclusions regarding the purpose of your date. As an accountant I naturally associated "tb" and "13 periods" to and ...
I wonder if there is any logic to formatting each named range differently. Would these be set 'at will' and different every time or are they 'predicta...
In the Added Custom1 step of the Sales_Bonuses query, just enter the column name as it is between square brackets. let val = [Sales Value] in Lis...
I started by recreating the scenario that was given in the picture. Then I copied that and filled in the numbers from your own example and arrived at ...
I've used SUMIFS. See attached. Would that solve it?
Based on stock number and price (or absolute value) alone, it will be difficult. I believe that is what Mynda pointed out in her response. What logic ...
The COSTOS table is in the wrong format you should get it into a the shape as shown in the attached file. But then, the DATA table has Year and Month ...
Remove Duplicates in PQ actually filters for distinct values. So, it returns every existing value once. If you want to keep only unique values (i.e. v...
"I hope that clears the fog." Not really. Sorry. You said you have two years of data. So, for the previous year, you would record grouped data in t...
You're welcome!
Well, than you can have a look at the file attached to post number 3. Best regards, R