Find Jobs
Hire Freelancers

Vlookup Query

₹600-1500 INR

Dokončeno
Zveřejněno před více než 6 roky

₹600-1500 INR

Zaplaceno při doručení
Need a formula to return sum of all matching values from a vlookup formula applied to a column. There are multiple entries of Same dates - Expenses arranged in a column and when i run a lookup, it either returns the largest or the smallest value from that column. what I need is a sum of all values matching the lookup criteria. Forexample Date -- Expenses 1-Mar-18 -- $15690 1-Mar-18 -- $200 5-Mar-18 -- $37890 When I run lookup for criteria matching "1-Mar-18", it should return "$15890" and not "15690" or "200".
IČ projektu: 15886104

O projektu

23 nabídky
Vzdálený projekt
Aktivní před 6 roky

Chcete si vydělat nějaké peníze?

Výhody podávání nabídek na Freelancer

Stanovte si rozpočet a časový rámec
Získejte za svou práci zaplaceno
Načrtněte svůj návrh
Registrace a podávání nabídek je zdarma
Uděleno:
Avatar uživatele
Hi, I would like to work on this task. I have a solution to get what you wish to get. Can get this done within 50 Mins. Looking forward to hear from you. Relevant Skills and Experience I have good experience working with Excel Tasks and can get them completed with accuracy and speed. Proposed Milestones ₹750 INR - Final Job Completion
₹750 INR v 0 dni
5,0 (54 recenze)
5,7
5,7
23 freelanceři nabízejí v průměru ₹1 035 INR za tuto práci
Avatar uživatele
A proposal has not yet been provided
₹1 500 INR v 1 dni
4,9 (86 recenze)
7,2
7,2
Avatar uživatele
Hello. I can do your project in less than an hour according to your description with full delivery and without error. I would also complete your project with the highest precision and quality. Relevant Skills and Experience I have extensive experience in Excel, Coding and Data processing. Proposed Milestones ₹1600 INR - A
₹1 600 INR v 1 dni
4,9 (185 recenze)
6,6
6,6
Avatar uživatele
i have good command over mS EXCEL especially pivot table, charts, advance formulas etc. Do let me know Relevant Skills and Experience Excel Proposed Milestones ₹850 INR - upon completion
₹850 INR v 0 dni
5,0 (38 recenze)
5,0
5,0
Avatar uživatele
Hello That can easily be done with a conditional function. Please feel free to send me your file and I can have it ready within the hour. Relevant Skills and Experience I have major experience working on excel. Please check my reviews as reference. Thanks for reading, Michael. Proposed Milestones ₹900 INR - Excel function
₹900 INR v 1 dni
5,0 (31 recenze)
4,3
4,3
Avatar uživatele
I can do it easily. Relevant Skills and Experience Excel and Power Query Proposed Milestones ₹600 INR - Project Conclusion
₹600 INR v 1 dni
5,0 (1 recenze)
3,0
3,0
Avatar uživatele
Hi, I am interested in your project and I would like to know more details. Kindly drop a message so we can discuss. Relevant Skills and Experience I have more then 5 years experience of advance excel such as lookups, pivots, macros, vbscripts etc. I have the relevant skills and experience to complete your work in given time frame. Proposed Milestones ₹300 INR - At the start of project ₹1000 INR - After final submission Please provide more details about work and also a sample for reference.
₹1 300 INR v 1 dni
4,3 (14 recenze)
3,6
3,6
Avatar uživatele
Hi, you should try combining sum with vlookup or sum with if. Please send me the sheet so I can take a look. Best regards, Relevant Skills and Experience Excel, data science Proposed Milestones ₹1300 INR - Review, add function/formula, validate, deliver
₹1 300 INR v 1 dni
5,0 (6 recenze)
2,9
2,9
Avatar uživatele
Hi there, It will be completed less than 5 hours depending on how many sheets should I work in. Relevant Skills and Experience Please visit my portfolio page for sure. Proposed Milestones ₹950 INR - final work milestone
₹950 INR v 0 dni
5,0 (2 recenze)
2,9
2,9
Avatar uživatele
CAN DO THE FORMULA AS PER REQUIREMENT Relevant Skills and Experience MANY YEARS OF EXP IN EXCEL. Proposed Milestones ₹600 INR - COMPLETION OF EXCEL
₹600 INR v 1 dni
5,0 (6 recenze)
1,6
1,6
Avatar uživatele
Knowledge of excel formula with which this job could be done easily. Relevant Skills and Experience Excellent Ms Excel skills coupled with fast typing Proposed Milestones ₹1500 INR - 100% task completion within stipulated timeline Additional Services Offered ₹500 INR - Data Analysis ₹100 INR - Editing
₹1 500 INR v 2 dnech
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
I can apply the V look up formula and solve your problem. Relevant Skills and Experience excel formula Proposed Milestones ₹950 INR - 1 day
₹950 INR v 1 dni
5,0 (1 recenze)
0,0
0,0
Avatar uživatele
I'm perfect for this project. Relevant Skills and Experience I have many skill and experience,if you want to know my skill then you work with me.i'm sure you like my work After complete the project. Proposed Milestones ₹850 INR - After complete the project I'll do the same thing as your given time. Do not let you be disappointed.
₹850 INR v 1 dni
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
it is very easy to sum all values to meet specific criteria in excel. if you allot me this task, I will complete it same day in your format as you wish Stay tuned, I'm still working on this proposal.
₹600 INR v 1 dni
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
Hi, Thank you for reviewing my bid. I will develop a custom formula to complete this task. Keashan Relevant Skills and Experience I'm a full time freelancer who providing excel/VBA related services. I'm having more than 4 years experience about this. Proposed Milestones ₹1300 INR - Job Completion
₹1 300 INR v 2 dnech
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
Gathering information. Work delivery. Employer verification and acceptance. Relevant Skills and Experience Excel experienced, for over more than 10 years. Attention to detail. Strong numerical skills. Proposed Milestones ₹5 INR - Gathering information. ₹5 INR - Work delivery. ₹590 INR - Employer verification and acceptance. Additional Services Offered ₹100 INR - Data analysis and any other Excel formula. I would like to help you.
₹600 INR v 1 dni
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
The ask can be accomplished using array formulas or sumifs function. Relevant Skills and Experience I work on Excel everyday, creating dashboards for top managements. Proposed Milestones ₹1250 INR - Provide me the sample data and I will send you the file back updated with the formula.
₹1 250 INR v 1 dni
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
Good at excel Relevant Skills and Experience Having working experience on excel Proposed Milestones ₹1050 INR - Can complete in 1 day
₹1 050 INR v 1 dni
0,0 (0 recenze)
0,0
0,0

O klientovi

Pochází z INDIA
Delhi, India
5,0
1
Členem od lis 3, 2017

Ověření klienta

Další zakázky od tohoto klienta

Microsoft Excel
₹1500-12500 INR
Díky! Poslali jsme vám e-mailem odkaz pro získání kreditu zdarma.
Při odesílání e-mailu se něco pokazilo. Zkuste to prosím znovu.
Registrovaných uživatelů Zveřejněných projektů
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Načítání náhledu
Bylo uděleno povolení ke geolokaci.
Vaše doba přihlášení vypršela a byli jste odhlášeni. Přihlaste se znovu.