Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to compare two sheets with repeating rows
I have two Excel sheets one is master roster of employees and the others
training courses( transactions file) taken by some of the employees. What I want to generate a list that shows courses taken by each employees if any(in the training sheet) and merge it in the roster sheet in fornt of each employee.( some employees have several courses & each course appear as a row in the Training sheet);i,e. Roster: Employee A number, name Employee B number , name Employee C number, name Training Sheet: Employee A number, name & course 1 Employee A number, name & course 2 Employee B number, name, course 4 Employee c number, name, course 1 Employee c number, name, course 2 Employee c number, name, course 4 Employee c number, name, course 7 so I need the result as follows: Employee A number, name, course 1, course2 Employee C number, name, course 1, course 2, course 4, course 7 etc I appreciate your suggestion |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Repeating rows in Excel | Excel Discussion (Misc queries) | |||
Repeating Rows | Excel Discussion (Misc queries) | |||
repeating data in other sheets | Excel Discussion (Misc queries) | |||
Repeating Rows | Excel Worksheet Functions | |||
delete repeating rows | Excel Worksheet Functions |