I have multiple headers in column A such as Employees, In Time, Out Time, Duration & Status
I need to first filter it and write formula to check the In Time & Out Time on each of the "Duration" rows
similarly once the output comes post writing the formula on "Duration" rows, I need to filter "Status" row and write another formula to get the FINAL Result
Once the formula is written and it shows the result, all the formulas should be paste special as values
Then filter the A column and select "status" rows with the result, same needs to be copied & pasted to another sheet (Attendance).
Sample Data pasted as image
Thank you so much in advance.
I need to first filter it and write formula to check the In Time & Out Time on each of the "Duration" rows
similarly once the output comes post writing the formula on "Duration" rows, I need to filter "Status" row and write another formula to get the FINAL Result
Once the formula is written and it shows the result, all the formulas should be paste special as values
Then filter the A column and select "status" rows with the result, same needs to be copied & pasted to another sheet (Attendance).
Sample Data pasted as image
Thank you so much in advance.
