Find Jobs
Hire Freelancers

Excel formula

€8-30 EUR

Complété
Publié il y a presque 5 ans

€8-30 EUR

Payé lors de la livraison
=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
N° de projet : 20759790

Concernant le projet

6 propositions
Projet à distance
Actif à il y a 5 ans

Cherchez-vous à gagner de l'argent ?

Avantages de faire une offre sur Freelancer

Fixez votre budget et vos délais
Soyez payé pour votre travail
Surlignez votre proposition
Il est gratuit de s'inscrire et de faire des offres sur des travaux
Décerné à :
Avatar de l'utilisateur
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 en 1 jour
5,0 (2 commentaires)
0,9
0,9
6 freelances proposent en moyenne €40 EUR pour ce travail
Avatar de l'utilisateur
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 en 1 jour
5,0 (41 commentaires)
5,5
5,5
Avatar de l'utilisateur
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 en 3 jours
4,8 (68 commentaires)
5,7
5,7
Avatar de l'utilisateur
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 en 1 jour
4,8 (25 commentaires)
4,5
4,5
Avatar de l'utilisateur
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 en 1 jour
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
Hello, I am an advanced excel user with years of data analysis and financial modeling experience. Let's get in touch.
€19 EUR en 1 jour
0,0 (0 commentaires)
0,0
0,0

À propos du client

Drapeau de SWITZERLAND
Basel, Switzerland
4,9
7
Méthode de paiement vérifiée
Membre depuis avr. 25, 2013

Vérification du client

Merci ! Nous vous avons envoyé un lien par e-mail afin de réclamer votre crédit gratuit.
Une erreur a eu lieu lors de l'envoi de votre e-mail. Veuillez réessayer.
Utilisateurs enregistrés Total des travaux publiés
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Chargement de l'aperçu
Permission donnée pour la géolocalisation.
Votre session de connexion a expiré et vous avez été déconnecté. Veuillez vous connecter à nouveau.