Hello My Masters ,I Want Your Help to Modify the formula for fetching all absence dates for each employee For $D$4:$AH$4 From Attendance and Absent Sheet To Search Sheet Start from A4
Code:
IFERROR(INDEX('Attendance and Absent'!$D$4:$AH$4,SMALL(IF('Attendance and Absent'!$B$6:$B$38=A$3,IF('Attendance and Absent'!$D$6:$AH$38="A",ROW(D$6:AG$535)-ROW(D$6)+1)),ROWS($A$4:A4))),"")