MIN MAX using duplicate values across 3 sets of numbers

Hi,

I just did a MIN function.

Follow attached.

Cheers!

Hi -

This would be a lot easier if you would post a sample spreadsheet as I can't tell what cells you have your data in, how it's organized, etc. Nonetheless, couldn't you just simply take the MIN() of Parts A, B and C for each group to determine the number of units (If A, B, or C is 0, then you can't make any). If A is the smallest, then you can only make that many; if B is smallest, you can only make that many, if C is smallest...etc. And then SUM() for the three groups to get the total.

I do have more below row 10... I have several areas with duplication parts within groups.

If you click on the Go Advanced button, then scroll down to Manage Attachments, then just follow the instructions to attach a file.

I really can't tell what you have from the picture. I don't see any of the kinds of numbers you mentioned in your example in the first post. The formula refers to cells that are not in the picture.

Originally Posted by loginjmor

If you click on the Go Advanced button, then scroll down to Manage Attachments, then just follow the instructions to attach a file.

I really can't tell what you have from the picture. I don't see any of the kinds of numbers you mentioned in your example in the first post. The formula refers to cells that are not in the picture.

Thanks so much for the tip... that helped

I should also mention I am looking at the KIT Column.

OK - I have your file. I can see you are getting the minimum number from Column J for your MIN/MAX in Column L. To get the total number from each group, wouldn't you now just simply SUM(L2:L10)? That would total 764 pieces. What am I missing?

OK - So let's see if I understand this:

First: Line 1 is the first group of A, B, and C. Line 2 is the next group, and Line 3 is the next group. Line 9 is not included in the file you posted?

Second: The amount listed under KIT is the total amount in column K less the amounts listed under the headings T, H, G, O? For example, row 2 of the spreadsheet is Part A for Line 1, the total of Part A is 9,366. KIT equals K2 - T2 - G2-H2-I2, which is 9366-735-3558-4309=764. Correct?

Third: You want to know after Line 3 (Row 8) consumes 764 parts of Part A, Part B, and Part C how much is left to feed Lines 4 through 9? Is that what you're looking for?

Good morning,

The Kit column is ready for build, parts in previous columns is stages before kit (in process).

the goal of the whole sheet is to know how many pcs across all parts I can build in a day (target). See attachment. Thanks again for taking your time to assist and give feedback and hopefully your ideas. : )

The 1's and 0's in column C represent first instance the part number appeared in the sheet. The zero means duplicate of the first instance.