Hello All,
I am working on a excel sheet to help me with log ins and log outs. I have a sheet called Data where I dump all the log ins and outs. There are a multiple number of Reps with different days they work. What I want to do is have their log in; 15min break; 30 min lunch; and log out for the day to appear in certain cells. I am using the Index and Matching functions.
For the Log In I use the following formula:
=INDEX(Data!$D$1:$D$10000,MATCH($D$3,IF(Data!$G$1:$G$1000=$A$8,Data!$A$1:$A10000,0),0))
It works great for the first Cell I paste it in but it gives me an #N/A Error for the rest of the cells.
Also for the Log Out cells I wanted to use the Large Function in combination with the Index and Match. But I am not able to figure out the correct format. Any help would be greatly appreciated.
Attached is my worksheet.
Thanks
Bookmarks