Create basic formulas in Excel Worksheet
$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
Awarded to:
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] More
36 freelancers are bidding on average $78 for this job
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. Pl More
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 Ra More
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
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
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, i More
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 More
The code is already ready for the project. If I am awarded, I can share you in 30 minutes. Regards,
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
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 w More
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 More
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
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.
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.
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.
