Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have an Excel file: payroll.xlsx

I need to do the following, but I'm not sure how:

Create a pivot table that computes per employee how many times s/he checked in and her/his average amount of time worked. There should be a block of rows in the table for each employee for whom you have payroll data, and each block should have separate entries for the number of shifts worked and the average time worked by that employee.

I'm not sure if the Excel file is just wrong or if I'm not doing it correctly. It's supposed to have: Employee Names (not Employee ID).

share|improve this question

migrated from stackoverflow.com Apr 19 '11 at 4:42

This question came from our site for professional and enthusiast programmers.

1 Answer 1

You need to add a column 'Employee Name' to the source table in column G. Do this with the following formula:

=VLOOKUP(A2,EmployeeData!A:B,2,FALSE)

Refresh your pivot table and use 'Employee Name' instead of 'Employee ID'.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.