Number of Cartons in a Pallet

Before looking at your file, I thought this sounded very much like a school assignment,

After looking at your file, I'm pretty much convinced that it is a school assignment.

Most of us who try to help people out with their Excel problems have agreed that we're not here to do homework for students. We generally would be willing to help if said student showed any effort in trying to get to the solution and simply ran into a roadblock, and was unable to get through that. So offering a suggestion under that kind of circumstance is OK.

If indeed you are a student--as I'm speculating--then I'm sending you back to take a decent stab at solving this on your own. That, my friend, is how you'll learn; not through having somebody solve it for you. If after devoting an hour or more to it (and showing what you've tried) you still are up against a roadblock, then come back, show us what you've tried, how you've scoped it out, what steps you've taken......

And if, per chance, you are not a student, then come back and give a plausible explanation for how such a neatly laid out spreadsheet appeared in your Excel window without your having some idea of how to approach it.