Iced42
New member
- Joined
- Jun 25, 2015
- Messages
- 11
- Reaction score
- 0
- Points
- 0
I have employees time card with Employee, location worked, ID number, hours, both regular and overtime hours and date worked. I’m trying to create a list of duplicate and unique listing of customer along with the associated information.
In other words if employee 1, worked Monday, at customer 1, location it would appear once and if (2) employees worked, at customer (1) it would appear (1) time. The employee 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 also really require a formula for this, if at all possible.
Thank you, hope someone can help.
In other words if employee 1, worked Monday, at customer 1, location it would appear once and if (2) employees worked, at customer (1) it would appear (1) time. The employee 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 also really require a formula for this, if at all possible.
Thank you, hope someone can help.
