| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Training matrix
I have a spreadsheet of people against course names with dates that training
is due for the individuals it is applicable to as shown below. I am trying to find out how I can pull from excel information telling me the month due for the people who need the courses on the left hand column. ATKINS PAUL BAKER DAVID BAKER TOM Training Topics Feb-09 Apr-09 Jun-09 Quality Leader May-09 Aug-09 Quality Engineer May-09 Jul-09 Sep-09 Quality Administrator May-09 Jun-09 Jul-09 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Training matrix
what do you want the info to do? what is your desired end result?
"talalhisham" wrote: I have a spreadsheet of people against course names with dates that training is due for the individuals it is applicable to as shown below. I am trying to find out how I can pull from excel information telling me the month due for the people who need the courses on the left hand column. ATKINS PAUL BAKER DAVID BAKER TOM Training Topics Feb-09 Apr-09 Jun-09 Quality Leader May-09 Aug-09 Quality Engineer May-09 Jul-09 Sep-09 Quality Administrator May-09 Jun-09 Jul-09 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Training matrix
Hi,
You can use =text(month(E3),"mmmmm") -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "talalhisham" wrote in message ... I have a spreadsheet of people against course names with dates that training is due for the individuals it is applicable to as shown below. I am trying to find out how I can pull from excel information telling me the month due for the people who need the courses on the left hand column. ATKINS PAUL BAKER DAVID BAKER TOM Training Topics Feb-09 Apr-09 Jun-09 Quality Leader May-09 Aug-09 Quality Engineer May-09 Jul-09 Sep-09 Quality Administrator May-09 Jun-09 Jul-09 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Training matrix
rite this is wat i need......
I have a big spreadsheet with employee names across the top and a list of courses that have been taken and training that is required by each individual. Some of the courses need refreshing every 6 months or 12 months. The middle section of the spreadsheet has dates of courses completed and dates of when they need to be done again. What I need to do is every month pull a report of the training required by individual name and course they need to do "Ashish Mathur" wrote: Hi, You can use =text(month(E3),"mmmmm") -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "talalhisham" wrote in message ... I have a spreadsheet of people against course names with dates that training is due for the individuals it is applicable to as shown below. I am trying to find out how I can pull from excel information telling me the month due for the people who need the courses on the left hand column. ATKINS PAUL BAKER DAVID BAKER TOM Training Topics Feb-09 Apr-09 Jun-09 Quality Leader May-09 Aug-09 Quality Engineer May-09 Jul-09 Sep-09 Quality Administrator May-09 Jun-09 Jul-09 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I transpose nXm matrix to mXn Matrix | Excel Worksheet Functions | |||
| F9 Training | Excel Discussion (Misc queries) | |||
| URGENT HELP: Establishing a Training Matrix | Excel Discussion (Misc queries) | |||
| how do i create a training matrix in excel | Excel Discussion (Misc queries) | |||
| Training | Excel Discussion (Misc queries) | |||
Linear Mode
