Hi, so I have a file very similar to this one. It is for work. Used to track clock in/out times from employees. I am trying to create a code to identify which employees are on the clock and which ones are not. I was doing a bunch of IF formulas nested but then I realized there could be more columns with clock punches due to duplicate/error punches. Essentially in simple terms I am requesting if there is any way to find out if the employee’s last punch was an In or an Out. That would be what I am looking for. Column E will always start with IN and always alternates. I am at lost with this. Thank you in advance! Here is a screenshot of a sample file