exampleexcel.jpg
Hi all,
In this example each negative is a case of us being over stock (i.e. -12 equals 12 units over) and each postive is us missing stock (i.e. batch QO534175D15 missing 168). The goal is to adjust off records that balance out. Normally I would SUMIF and filter to only zeroes to find each SKU that balances and adjust off all records for that SKU.
In this case I want to find cases where I can partially adjust records. The -12, -384 and +396 could all be adjusted off to each other perfectly wile leaving the other variances behind. Is there a way I can SUMIF for records like these per SKU that partially balance?
Currently I manually sift through thousands of these records looking for lines that balance.
Thanks, Anth
Bookmarks