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
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
How can I calculate which column contains the last time entry for multiple rows?
- Thread starter Indominus
- Start date
-
- Tags
- identify lookup value match
Wow thank you so much Fluff it works perfectly!!! How does this work exactly? I am trying to really up my knowledge and I have never heard of this function
Last edited:
Upvote
0
Fluff
MrExcel MVP, Moderator
- Joined
- Jun 12, 2014
- Messages
- 90,548
- Office Version
- 365
- Platform
- Windows
You're welcome & thanks for the feedback.
For how it works, have a look here Excel formula: Get value of last non-empty cell | Exceljet
For how it works, have a look here Excel formula: Get value of last non-empty cell | Exceljet
Upvote
0
Similar threads
- Question
- Question
