Last Station Used

[rsortilla]

[TABLE="width: 678"]
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Employee ID[/TD]
[TD]Name[/TD]
[TD]Workstation[/TD]
[TD]Login Date[/TD]
[TD]Login Time[/TD]
[TD]Logout Date[/TD]
[TD]Logout Time[/TD]
[/TR]
[TR]
[TD]ID00001[/TD]
[TD]Employee 1[/TD]
[TD]PC 1[/TD]
[TD="align: right"]9/1/17[/TD]
[TD="align: right"]8:00 AM[/TD]
[TD="align: right"]9/1/17[/TD]
[TD="align: right"]8:30 AM[/TD]
[/TR]
[TR]
[TD]ID00002[/TD]
[TD]Employee 2[/TD]
[TD]PC 2[/TD]
[TD="align: right"]9/1/17[/TD]
[TD="align: right"]8:30 AM[/TD]
[TD="align: right"]9/1/17[/TD]
[TD="align: right"]5:30 PM[/TD]
[/TR]
[TR]
[TD]ID00003[/TD]
[TD]Employee 3[/TD]
[TD]PC 3[/TD]
[TD="align: right"]9/1/17[/TD]
[TD="align: right"]10:00 AM[/TD]
[TD="align: right"]9/1/17[/TD]
[TD="align: right"]11:00 AM[/TD]
[/TR]
[TR]
[TD]ID00001[/TD]
[TD]Employee 1[/TD]
[TD]PC 4[/TD]
[TD="align: right"]9/1/17[/TD]
[TD="align: right"]8:45 AM[/TD]
[TD="align: right"]9/1/17[/TD]
[TD="align: right"]5:00 PM[/TD]
[/TR]
[TR]
[TD]ID00003[/TD]
[TD]Employee 3[/TD]
[TD]PC 5[/TD]
[TD="align: right"]9/1/17[/TD]
[TD="align: right"]11:03 AM[/TD]
[TD="align: right"]9/1/17[/TD]
[TD="align: right"]7:00 PM[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 263"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Employee ID[/TD]
[TD]Last Station Used[/TD]
[/TR]
[TR]
[TD]ID00001[/TD]
[TD] = What's the Formula?[/TD]
[/TR]
[TR]
[TD]ID00002[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I've been trying to solve this without using any VBA code to no avail. In this case, the employee can transfer to as many stations as he can.

 

[Aladin Akyurek]

Also worth to note: The suggested formulas expect a chrosnological recording of the logging events. If this is not the case, a different formula would be imperative...