I have column 1 and it has dates. I have column 2 and it has inventory sold. The dates are duplicated from several systems - which means for a given date there are at least 7-10 numbers for inventory sold. We simply want to take the highest amount for a specific date and show the SUM of that column for inventory. Mean we are only adding 1 inventory amount per date. Let's block ads! بخوانید...
ادامه مطلب