Required attendance

[Rahul Mishra]

Dear Sir,

As per attached excel sheet i required first in time and last out time according to format please help.

 

[bosco_yip]

Try,

In E2, copy across and down :

=IF($B2="",IFERROR(INDEX((Sheet2!$E$2:$E$13600,Sheet2!$F$2:$F$13600),MATCH(1,INDEX((Sheet2!$B$2:$B$13600=LOOKUP("zz",$B$1:$B1))*(Sheet2!$D$2:$D$13600=E$1),0),0),,MATCH($A2,{"First In";"Last Out"},0)),""),"")

Regards
Bosco

 

[Ramesh]

See if the attached file helps..

 

[Rahul Mishra]

sir thank you so much for it but it is very long method can you share some shore method for it in excel.

 

[Ramesh]

In such row & column values match based data retrival, the best approach I prefer to to introduce a helper column and write a Vlookup formula..

For having the formula copy / paste operation easy, I will place the first in and last out as column headers under each date and copy the formula..

I am here by attaching the updated report...

 

[Rahul Mishra]

sir in this first in time is showing same of all emp.

 

[Ramesh]

There was an issue with the cell reference in formula..I have fixed the same ..here is the updated file...