Need to build a macro that will record result in the defect type column f. If column d contains the word bag and column e = 1 then record defect type as oversize. Second calculation is to perform a count of distinct column d and then determine if that count is greater than 60 percent of its matching quantity of column e. If true then defect type recorded as pallet. Third calculation if distinct count of column d is equal or greater than 25, then record defect type as pallet. Sent sample of data but actual data has 261423 rows. Need by 5/2
Được trao cho:
28 freelancer đang chào giá trung bình $94 cho công việc này
Hi, I have been doing macro related works for some years and I can do the job described by you with perfection. I can start the job right now and can deliver in 12 hours at the most. Thank you.
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fourteen excel vba projects in the past seventy days. Willing to take up your project. Thank you, Regards.
Hi, I have seen your proposal. I am an excel expert with very good knowledge of VBA. I think I can do this job very efficiently. Kindly come on chat for more details. Thank you.