Excel formula

€8-30 EUR

Suoritettu

Julkaistu

lähes 5 vuotta sitten

€8-30 EUR

Maksettu toimituksen yhteydessä

=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

Projektin tunnus (ID): 20759790

Tietoa projektista

6 ehdotukset

Etäprojekti

Aktiivinen 5 vuotta sitten

Haluatko ansaita rahaa?

Sähköpostiosoite

Freelancerin tarjouskilpailun edut

Aseta budjettisi ja aikataulu

Saa maksu työstäsi

Kuvaile ehdotustasi

Rekisteröinti ja töihin tarjoaminen on ilmaista

Myönnetty käyttäjälle:

@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 päivässä

5,0

(2 arvostelua)

0,9

6 freelancerit tarjoavat keskimäärin €40 EUR tätä projektia

@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 päivässä

5,0

(41 arvostelua)

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 päivässä

4,8

(68 arvostelua)

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 päivässä

4,8

(25 arvostelua)

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 päivässä