Sep 28 2021 03:09 AM
Hi,
I'll try to explain this as quick/best I can
I want to create a formula that will determine how many pallets went out as a full pallet versus a partial pick.
For example, a full pallet of our products would be 60. 120 would be 2 pallets and so on.
Anything that is not divisible by 60 I would count as a partial pick and would not include in the report.
I was using COUNTIF's but they don't work 100% as if I use countif(range,120) it would count it as 1 pallet and not 2.
Any assistance would be appreciated as I've to do this for approximately 9000 rows.
Sep 28 2021 03:39 AM
@BarryRyan25 Two possible solutions included in the attached file.