Simple VBA with just 1 button.
$12-30 SGD
Paid on delivery
1) 2 Order above with different customers name with the same time zone = 0.7 points for the trip number.
2) Having the same postal code with 2 customers and 1 of the customers ordered twice, however the time zone is different, therefore each is being awarded with 1 point each
3) Having the same postal code with different customer which means that each is rewarded with 1 point. If there is more than 2 orders at the same postal code, refer back to criteria 1.
4) Having the same postal code and same customer name, however the instructions is written as "Click and Collect". The points should be awarded with this login (1,0,0)(1,0,0)(1,0,0). If they have 5 orders the points should be (1,0,0,1,0). Means that the loops is repeating.
5) Having the same postal code and same customer name, however the instructions is written as "VWO". No matter how many orders they had under the same customer name and same postal code, only 1 points is rewarded.
6) Having same postal code but quantity is more than 35 quantity in a single order is rewarded with 2 points.
7) Having same postal code but quantity is more than 46 quantity in a single order is rewarded with 3 points.
Project ID: #15364401
About the project
Awarded to:
Hi, just a job of few hours, can you send the excel file, so that I can send a demo. I can make the excel, just saving some time. Thanks
3 freelancers are bidding on average $26 for this job
Hello Sir. I have 5+ years experience in VBA. I can do this project very easily without any issue and in no time. Just message me so that we can start this project right now. Relevant Skills and Experience VBA Propos More