Making certain quantities a set?

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Hello andrew.ralston98 and Welcome to Excel Forum.
Try the following formulas
For the standard basket: =INT(MIN(Table2[QTY in stock]/E3:E6))
For the premium basket: =INT(MIN(Table2[QTY in stock]/F3:F6))
For the VIP basket: =INT(MIN(Table2[QTY in stock]/G3:G6))
Let us know if you have any questions.

Thanks! It works on the spreadsheet I attached, much appreciated.

Now it's trying to get it onto the correct spreadsheet.

How did you go about doing that? with the table2[qty in stock]?

I've been trying to implement it into the spreadsheet but don't understand it

The problem seems to be the merged & centered cells. Those should probably only be used when they will not be involved in further calculations. Even then Alignment (Ctrl 1) > Center across selection is a better option (IMO).
1. Paste the following into cell A4 and double click the fill handle to copy down to A34: =IF(B4="",A3,B4)
2. Paste the following into cell J4 and copy down: =MINIFS(G$4:G$34,A$4:A$34,I4)/MAXIFS(F$4:F$34,A$4:A$34,I4)
Note that the formula for column A could be placed in another column and/or hidden for aesthetic purposes.
Let us know if you have any questions.