Create basic formulas in Excel Worksheet

Виконано Опубліковано %project.relative_time Оплачується при отриманні
Виконано Оплачується при отриманні

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 -

Excel

ID Проекту: #8656916

Про проект

36 заявок(-ки) Дистанційний проект Остання активність Oct 11, 2015

Доручено:

aarifakhtar

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] Більше

$35 USD за 3 дні(-в)
(168 відгуків(-и))
7.1

36 фрілансерів(-и) готові виконати цю роботу у середньому за $78

RSUKANTA2014

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 Більше

$94 USD за 0 дні(-в)
(384 відгуків(и))
7.3
Harun1986

A proposal has not yet been provided

$155 USD за 3 дні(-в)
(160 відгуків(и))
6.5
watersev

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 p Більше

$30 USD за 0 дні(-в)
(255 відгуків(и))
6.6
raghav1101

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 Більше

$157 USD за 1 день
(95 відгуків(и))
6.6
citijayamala

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 за 3 дні(-в)
(87 відгуків(и))
6.2
sharifulhap

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 за 3 дні(-в)
(45 відгуків(и))
5.6
nagybatonyi

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 Більше

$40 USD за 1 день
(64 відгуків(и))
5.7
sonarkaushik

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 Більше

$77 USD за 3 дні(-в)
(43 відгуків(и))
5.6
serdaryalcin

The code is already ready for the project. If I am awarded, I can share you in 30 minutes. Regards,

$30 USD за 3 дні(-в)
(25 відгуків(и))
4.6
Pradeepj5061

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 за 1 день
(5 відгуків(и))
3.2
niyazmohaideen

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 Більше

$30 USD за 1 день
(11 відгуків(и))
2.9
alisa2015

A proposal has not yet been provided

$35 USD за 1 день
(2 відгуків(и))
2.9
Vateconsulting

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 Більше

$35 USD за 1 день
(1 відгук)
0.9
anjalityagi

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 за 1 день
(0 відгуків(и))
0.0
mohamedbakka12

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 за 3 дні(-в)
(0 відгуків(и))
0.0
samsuddoha75

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 за 3 дні(-в)
(0 відгуків(и))
0.0
aamirrauf

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 eff Більше

$111 USD за 3 дні(-в)
(0 відгуків(и))
0.0
Oumel

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 за 1 день
(0 відгуків(и))
0.0
elkardaboussi

Aucune proposition n'a encore été fournie.

$30 USD за 1 день
(0 відгуків(и))
0.0
ssmm15711571

A proposal has not yet been provided

$30 USD за 1 день
(0 відгуків(и))
0.0