How many numbers does it take to make a specified number full

[roelf888]

Good day, hope you guys are doing well. I have a little problem with some calculation regarding a specific number, and the different numbers it takes to make that number full. I will try and explain to the best of ability, so here goes.

example.png

What I want to do is, in the green cells, I want to display the hours for the categories that makes up the max specified hours. I have no idea how to make this happen except a manual exercise. Any help would be appreciated

Thanks

[Bernie Deitrick]

What values would you want displayed in the green cells? And can you explain the rules that you would want followed?

[FlameRetired]

Hi roelf888. Welcome to the forum.

Try this in L6:L8

Please Login or Register  to view this content.

[roelf888]

Thanks for the reply, but not really what I was looking, I did however find an answer at Stackoverflow

Thanks for the replies, really appreciated ! !

[roelf888]

I cant paste links, but let me know if someone want to see the other solution

[Glenn Kennedy]

What you COULD do is re-read rule 3....

https://www.excelforum.com/forum-rul...rum-rules.html

[FlameRetired]

I cant paste links, but let me know if someone want to see the other solution

Well then could you at least post the solution? There is no rule prohibiting this.

(I've gotten lost in the S-O labyrinth before.)

[roelf888]

Here is what the one guy proposed I do, I works up to 10, but as soon as the values in the data inout, goes to like 11 or 9, it does not properly allocate them into the categories.

CpsxE.png

It seems like you first need to calculate hours to date, check if that has reached 10, then start counting once limit is reached.


Where overflow is calculated by =IF(HoursToDate>10,HoursAddedOnThatDay,0)

And then IncludedHours = Sum(HoursAdded)-Sum(Overflow)

You can hide choose to hide/move the Overflow table as you like.

[samba_ravi]

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[AliGW]

Roel - this forum requires you to tell us WHERE you asked the same question. You can do this without links - just name the forum or forums, please. There will be no further help here until you have done so. Thanks.

[FlameRetired]

Ali,
Didn't OP do that in post #4?

Thanks for the reply, but not really what I was looking, I did however find an answer at Stackoverflow

Thanks for the replies, really appreciated ! !

[AliGW]

Ah, yes - missed that. The OP had completely ignored my post, anyway!