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

완료 등록 시간: 6년 전 착불
완료 착불

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

데이터 입력 데이터 처리 엑셀 비쥬얼 베이직 앱을 위한 비주얼 베이직

프로젝트 ID: #16866791

프로젝트 소개

26 건(제안서) 재택 근무형 프로젝트 서비스 이용 중: 6년 전

수상자:

conforti

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

$30 USD (2일 이내)
(10건의 리뷰)
3.7

이 일자리에 대한 프리랜서 26 명의 평균 입찰가: $97

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 기타

$150 USD (2일 이내)
(787 리뷰)
8.6
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 (1일 이내)
(962 리뷰)
8.1
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 기타

$100 USD (3일 이내)
(205 리뷰)
7.8
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 기타

$100 USD (2일 이내)
(406 리뷰)
7.3
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 (0일 이내)
(128 리뷰)
6.5
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 기타

$80 USD (0일 이내)
(113 리뷰)
6.4
sonarkaushik

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

$99 USD (2일 이내)
(104 리뷰)
6.2
usmanhassan123

A proposal has not yet been provided

$200 USD (1일 이내)
(86 리뷰)
6.3
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 기타

$50 USD (1일 이내)
(153 리뷰)
5.8
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 기타

$110 USD (2일 이내)
(22 리뷰)
5.3
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 기타

$55 USD (1일 이내)
(59 리뷰)
4.9
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 (3일 이내)
(48 리뷰)
4.6
jonyahmed105

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

$155 USD (3일 이내)
(4 리뷰)
3.3
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 기타

$35 USD (0일 이내)
(2 리뷰)
2.7
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 기타

$138 USD (3일 이내)
(2 리뷰)
2.3
Avisheka

This is a very simple project. I have over 12 years of experience in financial research. Please message me do that we can discuss this greater detail.

$88 USD (2일 이내)
(1 리뷰)
2.2
Adsdadd

i contact with you and understand what do you make it across macro or visual app and i promise you that i will start early and corporate with you will all my efforts and experience

$55 USD (3일 이내)
(0 리뷰)
0.0
yogeshdixit123

Good computer skills

$155 USD (3일 이내)
(0 리뷰)
0.0
aajkaarjun

I can do it by tomorrow if accepted today else might have to wait till 04th

$45 USD (2일 이내)
(0 리뷰)
0.0
ruksanamsd

A proposal has not yet been provided

$111 USD (3일 이내)
(0 리뷰)
0.0