Forum

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

I note you marked my post as the correct answer, although I haven't provided an answer yet. Now, if my assumptions are correct, the attached file cont...

I believe you need to clarify a few points. The table called "Table2" has Unit headers named "unit 2024" through "unit 2028". Then, the Income P...