I have a remainder question.
Column A: Group
Column B: Weight
Column C: Load - It needs to have a formula to max at 20000, and if there is a remaining weight in the group, it will add the remainder in the next row. However, no row can go over 20000, so it would do the same until the remainder was below 20000
In C2, use the formula
=MIN(20000,SUMIF(A:A,A2,B:B)-SUMIF($A$1:A1,A2,$C$1:C1))
and copy down to match column B.
Bernie Deitrick
Excel MVP 2000-2010
Thank you so much! Worked perfectly!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks