Find Jobs
Hire Freelancers

Excel formula

€8-30 EUR

완료함
게시됨 4년 이상 전

€8-30 EUR

제출할때 지불됩니다
=IF(K:K="";"Invoices open for analyse";IF(COUNTIFS(D:D;"Volvo Car Germany GmbH";O:O;"<>Finance");"Invoices pending NSC";IF(COUNTIFS(D:D;"<>Volvo Car Germany GmbH";D:D;"<>Choice GmbH");"Invoices pending DLR";IF(OR(H:H="CHOICE";H:H="CHOICE/ SP");"Invoices pending supplier";"")))) Criteria for column I Invoices new - Care ops comment empty (with latest dates over the week) Invoices open for analyze - Care ops comment empty (all with new) Invoices pending NSC - From supplier name: Volvo car Germany (without FINANCE-ownership) Invoice pending DLR- From Supplier name: no Volvo car Germany or Choice, but the rest, everything from ownership, except Choice, Kalyan, Delia Invoice pending Supplier - From Ownership, CHOICE and Choice/SP Invoice pending Internal - From Ownership, excludes NSC, the rest and from ownership CareOps back office, fleet management, service planning, digital support Invoice pending GFO - Ownership: Kalyan, Delia Invoices handled - Ownership: Handled
프로젝트 ID: 20759790

프로젝트 정보

6 제안서
원격근무 프로젝트
활동 중 5년 전

돈을 좀 벌 생각이십니까?

프리랜서 입찰의 이점

예산 및 기간 설정
작업 결과에 대한 급여 수급
제안의 개요를 자세히 쓰세요
무료로 프로젝트에 신청하고 입찰할 수 있습니다
프로젝트를 수여된 사용자:
사용자 아바타
Hi, My name is Alessio. I am experienced Data Analyst and Macro/Acces Developer. I have done similar jobs . I have read your instructions carefully. I have excellent knowledge and experience of creating User Form, Command Button, Drop Down, Radio Buttons, List Boxes etc. in excel VBA. I can start working on this project right away. Ready to start, please message me to discuss your project in more details. Thanks, Alessio
€10 EUR 1일에
5.0 (2 건의 리뷰)
0.9
0.9
6 이 프로젝트에 프리랜서들의 평균 입찰은 €40 EUR입니다.
사용자 아바타
VERY EASY FOR ME, I can do it within 30 min Hi, Nice to meet you. When it comes to Excel, Google Sheet, VBA, I am an expert Please see product I made recently using VBA and C#, python, java, excel management https://www.freelancer.com/projects/excel/Excel-Macro-pull-data-from/?w=f https://www.freelancer.com/projects/excel/Excel-VBA-Time-Series-Decomposition-20459676/?w=f https://www.freelancer.com/projects/excel/Build-appraisal-record-card/?w=f https://www.freelancer.com/projects/visual-basic-for-applications/Connect-Word-Userform/?w=f https://www.freelancer.com/projects/excel/Need-HELP-this-excel-form/?w=f https://www.freelancer.com/projects/php/create-outlook-add-rule-shortcut/?w=f https://www.freelancer.com/projects/data-entry/add-excel-table-rows-outlook/?w=f https://www.freelancer.com/projects/excel/Convert-Text-file-XML-file/?w=f https://www.freelancer.com/projects/data-entry/excel-expert-19406573/?w=f https://www.freelancer.com/projects/php/create-csv-file-using-parshub/?w=f https://www.freelancer.com/projects/excel/Compare-CSV/?w=f https://www.freelancer.com/projects/excel/ascii-excel-converter/?w=f https://www.freelancer.com/projects/software-architecture/Excel-xml-file-online-wizard/?w=f https://www.freelancer.com/projects/software-architecture/Combination-creator/?w=f I have a lots of experiences in Excel, Access and VBA programming After complete project, I can support fixing bugs with free. and support update features with low price. Please contact me. Thanks
€30 EUR 1일에
5.0 (41 건의 리뷰)
5.5
5.5
사용자 아바타
1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. I read your project description and I am sure that I can handle your project. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex markets. Experienced MBA Finance as well. 3. Your project will be delivered on time with high standard 4. Assistance will be provided with number of clarifications until client satisfaction
€150 EUR 3일에
4.8 (68 건의 리뷰)
5.7
5.7
사용자 아바타
I am postgraduate with more than 5 years of experience in advanced excel based tools, VBA automation, google scripting and data processing. I have successfully completed similar projects, please have a look at my portfolio for details. I have developed excel based automation tools for Ernst and Young also. You can get your work done here with highest quality at lowest price. Actual price and timeline will be decided after a discussion on exact requirements. Looking forward to work with you
€25 EUR 1일에
4.8 (25 건의 리뷰)
4.5
4.5
사용자 아바타
Dear client, firstly I would like to thanks review my proposal. I have reviewed & understand your project what you want. I do this job within time and 100% accuracy. I have 5 year experience in auto sector Mahindra & Mahindra PVT LTD for commercial assistance. I have expert in Microsoft Excel, data entry. My typing speed is 40wpm.I new in freelancer so my bid amount is low. So please give me a chance hires this project After comply t project, any kind of modification alteration will be provide free of cost Thanks/regards RAVI PATEL
€8 EUR 1일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
Hello, I am an advanced excel user with years of data analysis and financial modeling experience. Let's get in touch.
€19 EUR 1일에
0.0 (0 건의 리뷰)
0.0
0.0

고객에 대한 정보

국기 (SWITZERLAND)
Basel, Switzerland
4.9
7
결제 수단 확인
4월 25, 2013부터 회원입니다

고객 확인

감사합니다! 무료 크레딧을 신청할 수 있는 링크를 이메일로 보내드렸습니다.
이메일을 보내는 동안 문제가 발생했습니다. 다시 시도해 주세요.
등록 사용자 전체 등록 건수(일자리)
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
미리 보기 화면을 준비 중...
위치 정보 관련 접근권이 허용되었습니다.
고객님의 로그인 세션이 만료되어, 자동으로 로그아웃 처리가 되었습니다. 다시 로그인하여 주십시오.