• 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

juanito said:
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.
Click to expand...
@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!
 
You must log in or register to reply here.
Back
Top