Forum Discussion
Formula Help
CarlW1179 No worries. The formulas I used will only work with Excel for MS365. If you're getting the #NAME? error, it's a pretty strong indication that you're using an older version of Excel. I've attached another copy of the workbook, using the same logic, but with functions that should be compatible with any version...
CarlW1179 Please see the attached workbook for the complete solution I came up with. It uses the SCAN function to calculate the product allocations for each pallet. Hopefully this is what you were trying to accomplish...
That's exactly what I was trying to achieve rank you so much.
Only issue I now have is that when I change the Basket column the cell comes up with #NAME?
Really appreciate your help with this.
CarlW1179 No worries. The formulas I used will only work with Excel for MS365. If you're getting the #NAME? error, it's a pretty strong indication that you're using an older version of Excel. I've attached another copy of the workbook, using the same logic, but with functions that should be compatible with any version...
