scummins22
New Member
- Joined
- May 3, 2018
- Messages
- 12
Ok, so I am creating an attendance sheet. On one tab, I have a running list of employees that were tardy, left early, or absent and accrued points. On another tab, I have a roster of all the employee and I am wanting to create a different tab that list all employees with perfect attendance.
This is the formula I tried using but I am not getting what I need, can someone help me?
Input Sheet is the running list.(Column A is the Employee's Name, starting at A6)
Roster is the roster sheet. (Column C in the Employee's Name, starting at C2)
Perfect Attendance is the new sheet.
=IFERROR(LOOKUP(2,1/(COUNTIF($B$2:B2,'Input Sheet'!$A$6:$A$999999)=0),'Input Sheet'!$A$6:$A$999999),LOOKUP(2,1/(COUNTIF($D$2:D2,'Roster'!$C$2:$C$500)=0),'Roster'!$C$2:$C$500))
This is the formula I tried using but I am not getting what I need, can someone help me?
Input Sheet is the running list.(Column A is the Employee's Name, starting at A6)
Roster is the roster sheet. (Column C in the Employee's Name, starting at C2)
Perfect Attendance is the new sheet.
=IFERROR(LOOKUP(2,1/(COUNTIF($B$2:B2,'Input Sheet'!$A$6:$A$999999)=0),'Input Sheet'!$A$6:$A$999999),LOOKUP(2,1/(COUNTIF($D$2:D2,'Roster'!$C$2:$C$500)=0),'Roster'!$C$2:$C$500))
