Build a macro to perform calculations - 02/05/2018 14:20 EDT

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

Evner: Dataindførsel, Databehandling, Excel, Visual Basic, Visual Basic for Apps

Se mere: circuit board - 16/05/2017 00:13 EDT, Get a Website Built - 11/05/2017 13:24 EDT, Prepare Software Architecture Documents - 06/05/2017 23:00 EDT, data entry, data processing, visual basic for apps, microsoft excel, .672c0.396,0.348,0.636,0.899,0.636,1.535 c0,1.05.611,2.219H4.186 c-0.132-0.24-0.312-0.923-0.527-1.931c-0.24-1.115-0.684-1.535-, build ubuntu 14.04.05 LTS server , macro automation calculations, regularly summarize data build macro, perform calculations joomla web page, excel macro perform action website, build macro export outlook email text file, perform calculations adobe acrobat, adobe pdf perform calculations, perform calculations adobe, perform calculations pdf form, build macro download historical prices yahoo finance

Om arbejdsgiveren:
( 2 bedømmelser ) Gaylordsville, United States

Projekt ID: #16866791

Tildelt til:


Hello, i can do this job. Give me more details about it, please check my profile to see my qualifications

$30 USD in 2 dage
(9 bedømmelser)

28 freelancere byder i gennemsnit $94 på dette job


Hello Sir, Thank you for this opportunity. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community (https://www.freelancer.com/community/article Flere

$150 USD in 2 dage
(571 bedømmelser)

HI, I am good at Excel and vba Please share the excel file with the details. I will review and start working on the project. -Chandra

$100 USD på 1 dag
(688 bedømmelser)

Hello Sir Im excel VBA macro and formula Expert :) i can build excel macro like u need Sir :) please chat me for discuss detail of your project and after everything clear im able to start working today and complete Flere

$100 USD in 2 dage
(325 bedømmelser)

Dear Employer, I have read all your 3 conditions for MAcro. Please give me this opportunity. I will build the MAcro for you. I have more than 10 years of experience. Please share if any concern. Please share the Flere

$100 USD in 3 dage
(52 bedømmelser)

I am very able to create this macro to cqter your requirement.

$99 USD in 2 dage
(99 bedømmelser)
$80 USD in 2 dage
(43 bedømmelser)

A proposal has not yet been provided

$200 USD på 1 dag
(36 bedømmelser)

Hello, I am Luis and I can assist you as soon as you need! I can help you to fix your Excel problem. Please contact me by chat then we could discuss further details about this project! Looking forward to heari Flere

$50 USD på 1 dag
(81 bedømmelser)

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.

$55 USD på 1 dag
(69 bedømmelser)

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.

$155 USD in 0 dage
(25 bedømmelser)

Greetings for the Day!!! I have 8 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Serv Flere

$55 USD på 1 dag
(54 bedømmelser)

I have reviewed your specification, I would love to take a look at the workbook as well for some more context, if you are interested feel free to message me, looking forward to chat further for a quick turnaround solut Flere

$80 USD in 0 dage
(18 bedømmelser)

Regards, We are dedicated to the development of tools and solutions for SMEs and general users using the powerful excel tool. We also do not dedicate to statistical analysis and data science. We can develop Flere

$55 USD in 5 dage
(7 bedømmelser)

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.

$111 USD in 3 dage
(12 bedømmelser)

Hello there! If you would send me the example file and then tell me what to do exactly, then I can do this quickly for you. Note that I live in Hungary, so I can only answer with some hours of difference, but I can Flere

$35 USD in 0 dage
(2 bedømmelser)

Hi I can handle this task perfectly because I am exert like this task done. Thanks

$155 USD in 3 dage
(3 bedømmelser)

Hi, I have over five years experience in using Excel at an advanced level (formulas, array formulas, pivot table, macros, automatic calculation sheets) as an Industrial Engineer at Michelin. I am always keen to impro Flere

$110 USD in 2 dage
(1 bedømmelse)

A proposal has not yet been provided

$111 USD in 3 dage
(0 bedømmelser)

I can work remotely, developing the VBA Excel macros, like the project definitions. After finishing, I will send the worksheet with the macros applied for its tests and I will wait for its approval. If after the dead Flere

$155 USD in 2 dage
(0 bedømmelser)

Hi I am an excel expert with with strong knowledge of vba and I am a hard worker. My time zone is the same as yours then it will be easy to stay in touch and solve all the doubts. I am pretty sure i can do the macros Flere

$138 USD in 3 dage
(0 bedømmelser)