How can I calculate which column contains the last time entry for multiple rows?

Indominus

Board Regular
Joined
Jul 11, 2020
Messages
160
Office Version
  1. 2016
Platform
  1. Windows
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
 

Attachments

  • E15FC3C7-5B54-4663-BB58-035636D996A7.png
    E15FC3C7-5B54-4663-BB58-035636D996A7.png
    96.3 KB · Views: 13

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
How about
Excel Formula:
=LOOKUP(2,1/(E2:Z2<>""),$E$1:$Z$1)
 
Upvote 0
Solution
How about
Excel Formula:
=LOOKUP(2,1/(E2:Z2<>""),$E$1:$Z$1)
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

Forum statistics

Threads
1,223,893
Messages
6,175,246
Members
452,623
Latest member
cliftonhandyman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top