Using Solver to find parts of a sum with additional criteria

This post has been de-listed

It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.

Post Body

Hello everyone,

I need some help using the solver to find the parts of a sum, but also taking into consideration the values of another column.

The additional column I’m talking about would be lot numbers (inventory). I want the solver to prioritize its solutions by using the lowest value (oldest lot) first, if possible.

I am currently using a binary constraint in the solver to determine the parts of a sum, which works just fine, but is ineffective if I can’t prioritize using the oldest lots first.

Any help would be appreciated! Thank you in advance!

Edit: https://drive.google.com/open?id=18mYd82f1puAGfuy_Md0WtQreGshZxUBA

Link to the spreadsheet

Author

Account Strength

90%

Account Age

4 years

Verified Email

Yes

Verified Flair

Total Karma

2,671

Link Karma

Comment Karma

1,980

Profile updated: 4 days ago

Posts updated: 1 month ago

verycreativename8265

Subreddit

r/excel

Post Details

We try to extract some basic information from the post title. This is not always successful or accurate, please use your best judgement and compare these values to the post title and body for confirmation.

Posted: 4 years ago
Reddit URL: View post on reddit.com
External URL: reddit.com/r/excel/comme...