If this then this, else this.

[kenzemaitis]

Hi everyone,

I am working on a fairly large spreadsheet so any guidance would be fantastic. I have a column that is a percentage(p%), which also has a corresponding location(loc) and item column(ite). What I need to do is add as many items to one location as possible without exceeding 100%(p%), however if the value exceeds 100%(p%) then we need to start all over in a new location. The end result would be an unknown amount of unused locations.

If p% < 100 then add the next row's p% value, else start over with a new location. All I am looking to do is paste the item(ite) in a new column for each location.

Any suggestions?

[FrankBoston]

Sort the items by size large to small. These worksheet functions do the job for a medium number of bins (locations). It suggests an approach to fully automate the process. See also the attached workbook.

Please Login or Register  to view this content.

[kenzemaitis]

Sort the items by size large to small. These worksheet functions do the job for a medium number of bins (locations). It suggests an approach to fully automate the process. See also the attached workbook.

Please Login or Register  to view this content.

Worked beautifully, thanks a bunch!