Create basic formulas in Excel Worksheet

Concluído Postado Oct 10, 2015 Pago na entrega
Concluído Pago na entrega

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 do Projeto: #8656916

Sobre o projeto

36 propostas Projeto remoto Ativo em Oct 11, 2015

Concedido a:

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] Mais

$35 USD em 3 dias
(168 Comentários)
7.1

36 freelancers estão ofertando em média $78 nesse trabalho

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 Mais

$94 USD in 0 dias
(384 Comentários)
7.3
Harun1986

A proposal has not yet been provided

$155 USD in 3 dias
(160 Comentários)
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 Mais

$30 USD in 0 dias
(255 Comentários)
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 Mais

$157 USD em 1 dia
(95 Comentários)
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 in 3 dias
(87 Comentários)
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 in 3 dias
(45 Comentários)
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 Mais

$40 USD em 1 dia
(64 Comentários)
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 Mais

$77 USD in 3 dias
(43 Comentários)
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 in 3 dias
(25 Comentários)
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 em 1 dia
(5 Comentários)
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 Mais

$30 USD em 1 dia
(11 Comentários)
2.9
alisa2015

A proposal has not yet been provided

$35 USD em 1 dia
(2 Comentários)
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 Mais

$35 USD em 1 dia
(1 Comentário)
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 em 1 dia
(0 Comentários)
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 in 3 dias
(0 Comentários)
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 in 3 dias
(0 Comentários)
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 Mais

$111 USD in 3 dias
(0 Comentários)
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 em 1 dia
(0 Comentários)
0.0
elkardaboussi

Aucune proposition n'a encore été fournie.

$30 USD em 1 dia
(0 Comentários)
0.0
ssmm15711571

A proposal has not yet been provided

$30 USD em 1 dia
(0 Comentários)
0.0