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.

The inventories divide into six groups with three labels and four clips each.

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.

Six times three returns 18 labels, and six times four returns 24 clips.

Illustrated reconciliation. Check both totals against the original counts.

Microsoft’s GCD function reference