Đã hoàn thành

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

Kĩ năng: Nhập liệu, Xử lí dữ liệu, Excel, Visual Basic, Visual Basic cho Ứng dụng

Xem nhiều hơn: 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

Về Bên Thuê:
( 2 nhận xét ) Gaylordsville, United States

ID dự án: #16866791

Được trao cho:

conforti

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

$30 USD trong 2 ngày
(9 Đánh Giá)
3.6

28 freelancer đang chào giá trung bình $94 cho công việc này

jaylancer43

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 Thêm

$150 USD trong 2 ngày
(571 Nhận xét)
8.2
cgullapalli

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 trong 1 ngày
(688 Nhận xét)
7.7
prameswara

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 Thêm

$100 USD trong 2 ngày
(325 Nhận xét)
7.0
asin1987

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 Thêm

$100 USD trong 3 ngày
(52 Nhận xét)
6.2
sonarkaushik

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

$99 USD trong 2 ngày
(99 Nhận xét)
6.2
$80 USD trong 2 ngày
(43 Nhận xét)
5.3
usmanhassan123

A proposal has not yet been provided

$200 USD trong 1 ngày
(36 Nhận xét)
5.7
beltran0404

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 Thêm

$50 USD trong 1 ngày
(81 Nhận xét)
5.0
nwss1986

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 trong 1 ngày
(69 Nhận xét)
5.1
periyannas

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 trong 0 ngày
(25 Nhận xét)
4.7
prabakarm23

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 Thêm

$55 USD trong 1 ngày
(54 Nhận xét)
4.8
sloker18

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 Thêm

$80 USD trong 0 ngày
(18 Nhận xét)
3.9
soltecke

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 Thêm

$55 USD trong 5 ngày
(7 Nhận xét)
3.6
prasannjeetp

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 trong 3 ngày
(12 Nhận xét)
3.4
TheReaperCooL

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 Thêm

$35 USD trong 0 ngày
(2 Nhận xét)
2.8
jonyahmed105

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

$155 USD trong 3 ngày
(3 Nhận xét)
3.2
afenache

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 Thêm

$110 USD trong 2 ngày
(1 Nhận xét)
1.8
ruksanamsd

A proposal has not yet been provided

$111 USD trong 3 ngày
(0 Nhận xét)
0.0
RyamFonseca

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 Thêm

$155 USD trong 2 ngày
(0 Nhận xét)
0.0
jva5a3d4587b77b9

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 Thêm

$138 USD trong 3 ngày
(0 Nhận xét)
0.0