Morning happy campers,
Workbook attached
Blue cells - desired result from formula
Green cells - user input to feed formulae
As in the example, i would like the user to enter the full qty (K14) and the item (N13)
Cell H2 would then show how many full totes
Cell H18 would show how many part totes (always 1, otherwise its a full tote lol)
Cell K16 would show the full tote qty (how many can fit in a tote as per data range A2:C13) (already added formula)
Cell K18 would show the part tote qty
Cell L20 would show total numbe of totes (already added formula)
Would really appreciate some help on what would normally be a fairly simple task for me, but my daughter is teething so sleep is a rare commodity!!
very kind regards, galvinpaddy
Bookmarks