Find Jobs
Hire Freelancers

I need help with vlookup and pivot tables

$15-25 USD / hour

Fermé
Publié il y a presque 4 ans

$15-25 USD / hour

I need help with the following formula: =(INDEX($C$3:$C$13,SMALL(IF(D$2=$A$3:$A$13,ROW($A$3:$A$13)-MIN(ROW($A$3:$A$13))-2,"aadf"),ROW()-2),1,1)) I need for it to return a unique field
N° de projet : 26819787

Concernant le projet

28 propositions
Projet à distance
Actif à il y a 4 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
28 freelances proposent en moyenne $25 USD/heure pour ce travail
Avatar de l'utilisateur
Hi, Greetings! ✅checked your project details: vlookup and pivot tables ✅Completed Time: In project deadline We have worked on 600 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion.. Thank you Sandeep Digital screencast
$20 USD en 40 jours
4,9 (414 commentaires)
8,2
8,2
Avatar de l'utilisateur
NOTE : I HAVE EXPERTISE IN EXCEL AND VBA. I CAN COMPLETE THIS TASK IN QUICK TIME. With respect to this project I would like to present myself as a candidate for your consideration. I have more than 12 years of IT experience. I have successfully completed projects which involved Programming, scripting, excel. Key features of my work are as follows: 1) Always within schedule 2) Always within scope 3) Best tools and techniques used for the completion of tasks Looking forward to hear from you. Regards
$15 USD en 40 jours
5,0 (63 commentaires)
6,0
6,0
Avatar de l'utilisateur
Hello, I went thru the description Kindly send me the details and I will do it RIGHT NOW I look forward to hearing from you Thanks Regards Thushara
$15 USD en 10 jours
5,0 (31 commentaires)
4,9
4,9
Avatar de l'utilisateur
Hey there, I can help with pivot tables and lookups. Please let me know if you would like to discuss the project on a call or have a chat. Thanks, Md Irfaan Meah
$25 USD en 40 jours
5,0 (19 commentaires)
4,5
4,5
Avatar de l'utilisateur
Hello, My background i having worked with many complex Excel formulas and macros make me the best candidate for this work. Kindly message me to discuss further, I can help you with the formula easily. Regards, Shereena Wilson P
$25 USD en 10 jours
5,0 (13 commentaires)
4,5
4,5
Avatar de l'utilisateur
Hello, I will solve in five minutes .. I have gone through with contents and understand the requirements. I am interested to do this work and break your huddle. Please allow me to do this job. I am available to support you 24*7 just ping me once. I have a good knowledge of Excel, Advance Excel functions and VBA. I know Sumifs, Countifs, Averageifs, Index, Match, Vlookup, Hlookup, Sorting, Pivot table, Slicers, Developer functions & Conditional formatting, etc. Please check my portfolio to know more Thanks, Jitender Kumar
$22 USD en 40 jours
5,0 (15 commentaires)
4,5
4,5
Avatar de l'utilisateur
Greetings, Throughout my 35+ years career, I have used Excel extensively to manage the programs / projects / actions and the reporting requirements. Normalized/cleaned up lot of data, collected from various sources and made it easily usable using Excel. Provided numerous solutions in Excel using advanced functions, formulas, Pivot tables, custom & conditional formatting and visualization using innovative Graphs & Charts. Please refer to my portfolio. Keen to take up this assignment. You can be assured of clean and timely delivery. if proposed terms are the problem, we can discuss the same. Thank you for taking the time to read my proposal. Warm Regards
$20 USD en 40 jours
5,0 (2 commentaires)
2,5
2,5
Avatar de l'utilisateur
I can do it for you, I'm a professional Excel user with high speed, accuracy, and creativity. I've got a lot of experience in data entry and I'm familiar with this kind of project. Delivering on-time guarantee, I want to discuss more about this project details with you, and your satisfaction is my priority.
$15 USD en 40 jours
4,9 (4 commentaires)
2,1
2,1
Avatar de l'utilisateur
Hi, I am a Microsoft Certified Excel Expert and brings in years of experience working in Excel from data analysis point of view. I am well versed with all the formulas like Index...match, vlookup, hlookup etc. I am sure I can help you with your query about the formula but I will need more context to it. We can chat in detail. I am new to freelancing and would do my best to earn top rating and make a lifetime client :) Thanks!
$20 USD en 10 jours
5,0 (2 commentaires)
1,4
1,4
Avatar de l'utilisateur
Hands on experience of using vlookup and pivot tables . I am sure that you will satisfy with my work Relevant Skills and Experience With in short period of time i can report your work
$17 USD en 10 jours
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
I understand your project Plz contact me
$22 USD en 10 jours
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
Hello, I am an expert VBA developer with multiple projects experience ranging from automating a simple worksheet in Excel to creating a one click reporting solution spanning integration of different applications such as Excel, Outlook, PowerPoint, Access and Word. I can help you build complete dashboards from scratch or simply automate a segment of your work as per your requirement. I have 9+ years of experience creating customized VBA solutions, including: 1. Generating Custom Reports 2. Creating User Defined Functions 3. Data Analytics I have helped MNCs to optimize their tasks and according to their feedback modified my solutions to their complete satisfaction. I can build professional looking dashboard with customized inputs. In addition to my knowledge base, I actively seek out new technologies and stay up to date on industry trends and advancements. This has allowed me to stay ahead of the curve and deliver exceptional work to all my employers. Nearly all my engagements have led to repeat clients. I would love to work with you too. Looking forward to hearing from you. Thanks & Regards Aditya Mandan
$20 USD en 40 jours
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
I am quite experienced in Excel. I complete the project in the best and fastest way. Also, I have a lot of time because I am not working right now.
$15 USD en 100 jours
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
Hi! I am a graduate mathematician with many years of experience in developing mathematical models, analysis and software development, especially in C/C++ languages. My primary goal in software development is to deliver optimized, efficient, clean code and bug-free solutions. If I understood correctly, this formula is wrong because it needs to return a unique field, and it returns multiple fields. I checked, indeed the formula does not return a unique field. Can you explain to me what you want to get with this formula? It would be best to provide one example with the input data and the result that the formula should give. Are there any restrictions in the input data? Only in this way can I understand and correct the formula. In "Required skills" you have specified the C/C++ programming. You need to create a C/C++ program that will process the input data with the correct formula or just write this Excel formula correctly?
$20 USD en 9 jours
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
Will make sure it will be delivered on time
$22 USD en 10 jours
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
I am a lover of excel and would like to assist you with resolving your difficulty. A trial will convince you
$22 USD en 10 jours
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
HI If you have troubles getting Excel work for you, you need a bit of magic ;) And that's what wizzzards are for ;) Get back to me and I can fix your file up in no time warm regards your ExcelWizzzard making Excel work for you and not the other way round
$20 USD en 40 jours
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
Hi My name is Akash i have good experiance in data realted work i have done multiple projects in Data analyst and Data managment type of work
$20 USD en 30 jours
0,0 (0 commentaires)
0,0
0,0

À propos du client

Drapeau de UNITED STATES
El Paso, United States
0,0
0
Méthode de paiement vérifiée
Membre depuis août 3, 2020

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.