Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLookup or....?
So my situation is this, I have a workbook that consists of my employee's on each tab at the bottom. This is created to keep a record on them for things they do well, or things that, well, they don't well. One of the columns (Column C)is labeled "Incidents" and I have created a drop down list for this column. What I would like to do is this, on the first page of the workbook going down ColumnA is their names and across the top of each column a subject. It would look something like this: Column A Column B Column C Column D Column E Column F Row 1 Row 2 Item1 Item2 Item3 Item 4 Item 5 Row 3 Row 4 emp1 Row 5 emp2 Row 6 emp3 Row 7 emp4 Row 8 emp5 Item's 1-5 are what's in the drop down list in Column C. On the first sheet, I would like a total of how many times Item1 popped up in Column C for each employee. And the same for each item for each employee, so I can see how many times they stayed late to help out, or how many times I have received a complaint from a Customer. Thanks for the help -- respinosa ------------------------------------------------------------------------ respinosa's Profile: http://www.excelforum.com/member.php...o&userid=35231 View this thread: http://www.excelforum.com/showthread...hreadid=550089 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP Problem | Excel Discussion (Misc queries) | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |