Excel formula

€8-30 EUR

Selesai

Disiarkan

hampir 5 tahun yang lalu

€8-30 EUR

Dibayar semasa penghantaran

=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

Excel

Statistical Analysis

ID Projek: 20759790

Tentang projek

6 cadangan

Projek jarak jauh

Aktif 5 tahun yang lalu

Ingin menjana wang?

Alamat e-mel

Faedah membida di Freelancer

Tetapkan bajet dan garis masa anda

Dapatkan bayaran untuk kerja anda

Tuliskan cadangan anda

Ianya percuma untuk mendaftar dan membida pekerjaan

Dianugerahkan kepada:

@alemarta92

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 dalam 1 hari

5.0

(2 ulasan)

0.9

6 pekerja bebas membida secara purata €40 EUR untuk pekerjaan ini

@valor312

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 dalam 1 hari

5.0

(41 ulasan)

5.5

@citijayamala

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 dalam 3 hari

4.8

(68 ulasan)

5.7

@bhupendrayadav

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 dalam 1 hari

4.8

(25 ulasan)

4.5

@rp83498169

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 dalam 1 hari