• 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.

Problem in creating a formulaic solution to avoid iteratative calculation to allocate values

oren27

New Member
I am trying to replace a long iterative calculation with a simple formula as explained within the attached spreadsheet. ideally it will be done with formulas rather than macros, but any solution would be appreciated.

thanks much
 

Attachments

  • spreadsheet2.xlsx
    14.5 KB · Views: 5
Hi Oren ,

Going by your explanation , since it involves iteration , I think a macro will be far more simple compared to formulae.

Narayan
 
Any help in devising the solution would then be appreciated. let me know if my problem is articulated clearly enough.
 
Hi Oren ,

The problem is clearly stated , no problem.

To test the macro , at least 20 to 50 rows of data would be required , so that there is enough variety ; if you can upload a file with some real data , not made-up values , that would help.

It would be nice if you could upload a file where you have already manually worked out the outputs , so that what ever results are obtained with the macro can be cross-checked with the manually obtained results.

Narayan
 
Back
Top