I have employees time card with Employee, location worked, ID number, location, Hours, both regular and overtime hours and date worked. I’m trying to create a list of somewhat duplicate and unique listing of customer.


In other words if employee 1, worked Monday, at customer 1, location it would appear once and if (2) employees worked it would appear (1) time. Their Time is horizontal to the Vertical listing of the customer name.
The problem I’m having is (i.e.), is let say employee 1 and 2, are at customer 1, location on Monday, and employee 2, is back on Tuesday to customer 1, the formula I am using is removing the customer location on Tuesday from the list do to a duplicate name. (?).



I have attachment showing the above information along with a table showing the table that I’m trying to create. I have also circled the list that I am trying to compile into the other list.



I also really require a formula for this, if at all possible.



Thank you hope some can help.


My first post I apologize if done incorrectly.

Attached Files

Billing .xlsx (58.3 KB, 14 views)