You have 18 labels and 24 clips. To make the most identical kits while using every item, divide both inventories by their largest common divisor.
Find the number of identical kits
Put 18 in B2 and 24 in C2. In D2 enter:
=GCD(B2,C2)The result is 6. That gives 3 labels and 4 clips in each kit.

Illustrated kit split. The same quantities go into every kit.
Multiply back to the inventory counts
Confirm that 6 × 3 = 18 and 6 × 4 = 24. If you have 17 labels and 24 clips, the divisor is 1, so the rule makes one kit. For a fixed kit size, calculate leftovers separately. Use positive whole counts and decide how to handle an unavailable item before applying the formula.

Illustrated reconciliation. Check both totals against the original counts.



