Recent content by juanito

Thanks Monty for your share. I will follow up the platforms you mention.

I'm trying to find a solution for this: my company's current model is using a dangerously old Excel version (developed 1997!!). I'm finding it surprisingly hard to find one, especially ones for sale where the provider guarantees upgrades and bug fixes for a defined period. (There are plenty of...

@John Jairo V I believe I managed to replicate your LET function using Named Formulas. Thanks so much for your help. See attached. One more thing: I seem to have resolved this without recourse to either your variable f or the complex SWITCH / CHOOSE ... your thoughts? juanito

Thanks @Peter Bartholomew (and apologies for not responding earlier). Unfortunately, the order requirement doesn't suit my model and I was looking for a more general solution - which I have now found thanks to the support on this thread

Interesting, I will follow up

That is awesome, sir! My (corporate) version of 365 doesn't support LET yet - however I believe I may be able to replicate the functionality using named formulas... it may take me a day or two to confirm.

Impressive stuff p45cal - some non-interface M coding in there, it would appear? Many thanks...

Thanks vletm! And your solution does indeed evaluate correctly, independent of row order. Well done! Ideally I would have found a formula solution but your code does the job. Best, juanito

Hi vletm! By a general solution I mean for a data table with any number of entries and sorted in any order. The Values should be weighted by each "OU", depending on total Hours. I believe that the initial attachment that I included should be sufficiently indicative, but I am very happy to expand...

Thanks! In this case we are still without a "general" solution. It may be that there isn't a satisfactory answer and I must find an alternative method (PQ perhaps).

Hi again vletm and I sincerely appreciate you staying close to this. It is true that your example was similar in structure but the data was a little different, so I was wrong to expect the same result. I took your model and pasted in the exact same data. Your Solve evaluated to 71% when the...

Thanks, bosco_yip! The problem with this approach is that the rows must be ordered in pairs, correct? I am looking for a more general solution which works independently of order and references column C...

Thanks again vietm... only problem here is that the evaluation doesn't give the correct answer!!

Thanks John - fascinating use of MMULT, a function which I keep telling myself I need to understand better. But it doesn't give me the general solution I am seeking, which would function over a potentially larger dataset, with rows in any order etc...

Thanks vletm! Going to sleep now but more tomorrow I promise!