Notifications
Clear all
Hi David
Thanks for your feedback and compliments
By helping you, I have also learned a thing or two. Otherwise I wouldn't have even look at such a situation.
Sunny
Posted : 29/09/2017 11:24 pm
Topic starter
Allow me Sunny I modified the formula a bit. ie Put a conjunction( two condition ) in the If command to make it more precise.
Posted : 30/09/2017 2:34 am
Hi David
You can modify to suit your needs.
Just remember that the 1st row must be the delivered value e.g. cells D4, D16 etc Otherwise the formula will fail.
I noticed that quite a number of rows (e.g. rows 43, 46, 49 etc) for the delivered values are not added in your attachment. I suggest you add them BEFORE you copy the formulas to prevent any problem.
Sunny
Posted : 30/09/2017 2:52 am
Topic starter
Thanks Sunny the remind..
Posted : 03/10/2017 8:55 pm
Page 2 / 2
Prev
