gemchild79
New Member
Hello! I am looking to find the second occurrence of data using this spreadsheet. What I am needing to locate is the amount of time for the second break that was taken by each employee. The breaks are all coded with the number 3 in the D column of the sheet titled 'Monday'. I need to pull the amount of time the employee took for their break from column E in the corresponding row. Where I am having trouble is pulling the second break information because it is also coded with the number 3. I have included the sheets I am working with and here is the code used to find the original break period:
=IF(OR(B3="",D3="NCNS",D3="Sick",D3="absent",D3="vac",D3="term"),"",INDEX('Mon State Detail'!A:E,MATCH(1,('Mon State Detail'!A:A=A3)*('Mon State Detail'!D:D=3),0),5))
I greatly appreciate all of your help!
=IF(OR(B3="",D3="NCNS",D3="Sick",D3="absent",D3="vac",D3="term"),"",INDEX('Mon State Detail'!A:E,MATCH(1,('Mon State Detail'!A:A=A3)*('Mon State Detail'!D:D=3),0),5))
I greatly appreciate all of your help!