Excel formula

€8-30 EUR

Ολοκληρώθηκε

Αναρτήθηκε

περίπου 5 χρόνια πριν

€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

Excel

Statistical Analysis

Ταυτότητα εργασίας: 20759790

Σχετικά με την εργασία

6 προτάσεις

Απομακρυσμένη Εργασία

Ενεργός/ή 5 χρόνια πριν

Ψάχνεις τρόπο για να κερδίσεις μερικά χρήματα;

Διεύθυνση Email

Πλεονεκτήματα πλειοδοσίας στο Freelancer

Καθόρισε τον προϋπολογισμό σου και το χρονοδιάγραμμα

Πληρώσου για τη δουλειά σου

Περίγραψε την πρόταση σου

Η εγγραφή και η πλειοδοσία σε εργασίες είναι δωρεάν

Βραβεύτηκε στον/στην:

@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 σε 1 ημέρα

5,0

(2 αξιολογήσεις)

0,9

6 freelancers δίνουν μια μέση προσφορά €40 EUR για αυτή τη δουλειά

@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 σε 1 ημέρα

5,0

(41 αξιολογήσεις)

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 σε 3 ημέρες

4,8

(68 αξιολογήσεις)

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 σε 1 ημέρα

4,8

(25 αξιολογήσεις)

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 σε 1 ημέρα