• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Weighted average in flat file

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.
@John Jairo V I believe I managed to replicate your LET function using Named Formulas. Thanks so much for your help.
72444

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
 

Attachments

  • WeightedAverageSolution.xlsx
    61.7 KB · Views: 3
Hi again, @juanito!

If you need the result table, and not just the percentage, the solution I provided is an option (pivot tables, VBA, and another things).
But if you want a single answer, you can use the @Peter Bartholomew option with the Filter function, for example.

At the end, you are the person that choose what is better. Blessings!
 
Back
Top