Find Jobs
Hire Freelancers

Create basic formulas in Excel Worksheet

$30-250 USD

Completed
Posted over 8 years ago

$30-250 USD

Paid on delivery
I have a very basic table showing a list of students listed by username along the left column with the courses they took online in columns to the right along with basic info like start date, end date, certification expire date. Usually the username in column A appears 3 time in a row (as they took three training programs, each listed in a row to teh right of the username). But sometimes the student only took one program so the username is listed only once. I have been trying to use the Vlookup function along with various count an match functions to lookup the 2nd, 3rd instance of that username and show the data from those rows listed vertically, off to the right of the student name. Example Student Training Course Start Date Finish Date Jim Economics 5/1/15 7/12/15 Jim Math 7/15/15 9/16/15 Jim French 7/25/15 9/12/15 Jane French 3/30/15 4/30/15 I simply one to create ONE row per student that contains all their course info: Jim Economics 5/1/15 7/12/15 Math 7/15/15 Jame French 3/30/15 4/30/15 -
Project ID: 8656916

About the project

36 proposals
Remote project
Active 9 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi: Vlookup function is not designed to look for multiple matches. It only finds the first match. Look at this webpage: [login to view URL] .Hope you find this helpful. In case, you are unable to do it, please let me know. I will help you out.
$35 USD in 3 days
4.9 (168 reviews)
7.1
7.1
36 freelancers are bidding on average $78 USD for this job
User Avatar
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.in/u/RSUKANTA2014.html I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sourabha Roy.
$94 USD in 0 day
5.0 (384 reviews)
7.3
7.3
User Avatar
A proposal has not yet been provided
$155 USD in 3 days
4.9 (160 reviews)
6.5
6.5
User Avatar
Hi there, I have a vast experience in Excel and VBA and would be happy to help you on the project. Best regards, Eugene PS. I would suggest to use a VBA approach. The code is ready, file is processed. I'm ready to provide both.
$30 USD in 0 day
5.0 (255 reviews)
6.6
6.6
User Avatar
Hi I would love to work on this project. I have 8 years of experience in Microsoft Excel including working with excel modeling, dashboards and macros. Please contact with further details if interested. Regards Raghav Bansal
$157 USD in 1 day
4.9 (95 reviews)
6.6
6.6
User Avatar
expert in excel and excel functions formulas vlookup concepts macros pivot tables charts graphs VBA. experienced MBA finance as well can create spreadsheet as per the example
$56 USD in 3 days
4.7 (87 reviews)
6.2
6.2
User Avatar
Hi, I have read your posting job carefully. I am looking for a job like this. I can do your job perfectly and also assure you that my work will be 100% satisfied to you. Best regards Shariful
$155 USD in 3 days
5.0 (45 reviews)
5.6
5.6
User Avatar
I'm afraid there is no way to do this job with built in Excel functions, but I can offer a simple macro to do it. I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering a Control sheet containing cells populated by the usual Open file and/or select folder dialogs to identify the current input and output files (or the folders containing them, as required by the job) and hosting command buttons and other controls if necessary. In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. I can start working on the project immediately and complete the job within some hours. Regards
$40 USD in 1 day
4.9 (64 reviews)
5.7
5.7
User Avatar
Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences and will deliver flawless work. I am very much able to work on this. ***I am ready to start Waiting for further dlliscussion.. with thanks and regards
$77 USD in 3 days
4.6 (43 reviews)
5.6
5.6
User Avatar
The code is already ready for the project. If I am awarded, I can share you in 30 minutes. Regards,
$30 USD in 3 days
5.0 (25 reviews)
4.6
4.6
User Avatar
hello mate, how you doing? i can write the formula and share to you on basis of the project description you have given. waiting for your reply
$72 USD in 1 day
5.0 (5 reviews)
3.2
3.2
User Avatar
Hi, I can combine the rows in the excel sheet of same username information and displaying program as separate cells by writing code in C# or by using Macros. I am finding it difficult by using formulas in excel. I will be able to do it easily by writing code in C#. Looking forward to work with you and waiting for your reply.
$30 USD in 1 day
5.0 (11 reviews)
2.9
2.9
User Avatar
A proposal has not yet been provided
$35 USD in 1 day
5.0 (2 reviews)
2.9
2.9
User Avatar
Edit: I have completed the VBA script for you data. it has organised all of the students so they have one row and each of their programs following on. There are no duplicate student rows as I have deleted them. The script will allow you to run a macro each time you pull a report like this to organise the programs by student. I will now start work on the incell formulas if that is the direction you would like to take. Thank you, Ellen Greeting, I have had a look at the spreadsheet you have uploaded and I can organize it in the way you require. I analyze and format data like this for my regular day job. I may need to use Visual basic but it it a very quick job. I have already started work coding this up for you with both a VBA script and in cell formulas so should you decide you want to hire me, you will not be waiting very long! I do have one question for you however, once the data has been put on one line, can the surplus lines be deleted? I can do either way, whatever is best for you. Please feel free to ask me any questions about my work. Thank you, Ellen Vate Consulting
$35 USD in 1 day
4.8 (1 review)
0.9
0.9
User Avatar
I have downloaded your worksheet and completed the task already. Your final sheet is ready. Please award the project and receive the completed sheet immediately, if you wish. Best regards, Anjali
$50 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I am an expert in Data Entry/Data Processing. Quality and client satisfaction is my priority. Being highly available, I can guarantee you delivery in time.
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Hiring Manager I have necessary skills and expertise to deliver the project in proposed time. I will ensure the highest standard. I am open for discussion.
$222 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello! Hope so you will be fine. I have read all the details provided in your project and also viewed the attachment. I have a 3 years working experience in the relevant field and i will do your project asap in an efficient and effective way that you will be 100% satisfied with it. Thanks Regards Aamir Rauf
$111 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Rapide en la saisie de donnée et je manipule très bien les fonctions dont vous avez besoin pour cette tâche. Je respecte très bien les délais qu'on m'accorde.
$103 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Aucune proposition n'a encore été fournie.
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
United States
5.0
1
Payment method verified
Member since Feb 17, 2010

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.