Distribute Weekly Values Into Defined Portions

[novihermawan]

Hi ALL

Can you help me to make a formula with multiple criteria , as attach file

thanks in advance

[FDibbins]

What may be obvious to you, is not to us. Please explain - in detail - what you ar working with, what you are trying to do and what your expected outcome is.

[novihermawan]

Thanks for the respon

we need your help about the formula will be used .
I will try to explain that we have database on table 1, based on weekly basis, then any criteria in percent for grouping become 4 groups (ABCD).
Then base on table 1 need to be split based on grouping like result on table 3.

Need formula used so that the results like row7 start coloum AK until BR

I think you have clear after I explain

thanks

[AliGW]

Administrative Note:

Your thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. I have done it for you this time.)

[Glenn Kennedy]

I do not understand how the criteria are being applied. How would you calculate the results manually?

[AliGW]

I do. You add to bin A until it is full based on the values in columns T to W, then move on to bin B, etc. AK + AP = T, etc.

Does this help?

[nick.williams]

Try this in AK7, copied to the other cells:

Please Login or Register  to view this content.

[kvsrinivasamurthy]

Does macro will do?