So, I'm trying to get the latest information based on dates for flying.
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>[TABLE="width: 0"]
<colgroup><col style="width: 113px"><col width="147"><col width="170"><col width="100"><col width="152"><col width="133"><col width="100"><col width="100"></colgroup><tbody>[TR]
[TD="colspan: 6"]IM, APILOT[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Aircraft[/TD]
[TD]Date[/TD]
[TD]Hours[/TD]
[TD]Seat[/TD]
[TD]Takeoff In "L" Seat?[/TD]
[TD]Landing In "L" Seat?[/TD]
[TD](IF T/O in L)[/TD]
[TD](IF Land in L)[/TD]
[/TR]
[TR]
[TD="align: right"]111[/TD]
[TD="align: right"]9/1/17[/TD]
[TD="align: right"]1[/TD]
[TD]L[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD="align: right"]9/1/17[/TD]
[TD="align: right"]9/1/17[/TD]
[/TR]
[TR]
[TD="align: right"]111[/TD]
[TD="align: right"]9/2/17[/TD]
[TD="align: right"]1[/TD]
[TD]L[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD="align: right"]9/2/17[/TD]
[TD="align: right"]9/2/17[/TD]
[/TR]
[TR]
[TD="align: right"]111[/TD]
[TD="align: right"]9/3/17[/TD]
[TD="align: right"]1.2[/TD]
[TD]L[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD="align: right"]9/3/17[/TD]
[TD="align: right"]9/3/17[/TD]
[/TR]
[TR]
[TD="align: right"]111[/TD]
[TD="align: right"]9/4/17[/TD]
[TD="align: right"]0.2[/TD]
[TD]R[/TD]
[TD]No[/TD]
[TD]Yes[/TD]
[TD][/TD]
[TD="align: right"]9/4/17[/TD]
[/TR]
[TR]
[TD="align: right"]111[/TD]
[TD="align: right"]9/5/17[/TD]
[TD="align: right"]1.6[/TD]
[TD]R[/TD]
[TD]No[/TD]
[TD]Yes[/TD]
[TD][/TD]
[TD="align: right"]9/5/17[/TD]
[/TR]
[TR]
[TD="align: right"]111[/TD]
[TD="align: right"]9/6/17[/TD]
[TD="align: right"]3.2[/TD]
[TD]L[/TD]
[TD]No[/TD]
[TD]Yes[/TD]
[TD][/TD]
[TD="align: right"]9/6/17[/TD]
[/TR]
[TR]
[TD="align: right"]111[/TD]
[TD="align: right"]9/7/17[/TD]
[TD="align: right"]1.2[/TD]
[TD]R[/TD]
[TD]Yes[/TD]
[TD]No[/TD]
[TD="align: right"]9/7/17[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]111[/TD]
[TD="align: right"]9/8/17[/TD]
[TD="align: right"]1[/TD]
[TD]L[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD="align: right"]9/8/17[/TD]
[TD="align: right"]9/8/17[/TD]
[/TR]
[TR]
[TD="align: right"]111[/TD]
[TD="align: right"]9/9/17[/TD]
[TD="align: right"]1.4[/TD]
[TD]L[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD="align: right"]9/9/17[/TD]
[TD="align: right"]9/9/17[/TD]
[/TR]
[TR]
[TD="align: right"]111[/TD]
[TD="align: right"]9/10/17[/TD]
[TD="align: right"]3[/TD]
[TD]L[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD="align: right"]9/10/17[/TD]
[TD="align: right"]9/10/17[/TD]
[/TR]
[TR]
[TD="align: right"]111[/TD]
[TD="align: right"]9/11/17[/TD]
[TD="align: right"]3.1[/TD]
[TD]R[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD="align: right"]9/11/17[/TD]
[TD="align: right"]9/11/17[/TD]
[/TR]
[TR]
[TD="align: right"]111[/TD]
[TD="align: right"]9/12/17[/TD]
[TD="align: right"]2[/TD]
[TD]R[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD="align: right"]9/12/17[/TD]
[TD="align: right"]9/12/17[/TD]
[/TR]
[TR]
[TD="align: right"]111[/TD]
[TD="align: right"]9/13/17[/TD]
[TD="align: right"]2.5[/TD]
[TD]L[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD="align: right"]9/13/17[/TD]
[TD="align: right"]9/13/17[/TD]
[/TR]
[TR]
[TD="align: right"]111[/TD]
[TD="align: right"]9/14/17[/TD]
[TD="align: right"]2.7[/TD]
[TD]R[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD="align: right"]9/14/17[/TD]
[TD="align: right"]9/14/17[/TD]
[/TR]
[TR]
[TD="align: right"]111[/TD]
[TD="align: right"]9/15/17[/TD]
[TD="align: right"]5[/TD]
[TD]R[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD="align: right"]9/15/17[/TD]
[TD="align: right"]9/15/17[/TD]
[/TR]
</tbody>[/TABLE]
What I'm trying to get is the latest Takeoff and Latest landing ONLY From the "L" Seat. Sum hours is easy, but I cant seem to get the last takeoff and landing of this particular sheet. The information is autopouplated, and isn't always in order, so I've had issue with the sort function. Please Help! THANKS!!!
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>[TABLE="width: 0"]
<colgroup><col style="width: 113px"><col width="147"><col width="170"></colgroup><tbody>[TR]
[TD]Hours This Month[/TD]
[TD]Last Takeoff ThisMonth[/TD]
[TD]Latest Landing This Month[/TD]
[/TR]
[TR]
[TD="align: right"]30.1[/TD]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
</tbody>[/TABLE]
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>[TABLE="width: 0"]
<colgroup><col style="width: 113px"><col width="147"><col width="170"><col width="100"><col width="152"><col width="133"><col width="100"><col width="100"></colgroup><tbody>[TR]
[TD="colspan: 6"]IM, APILOT[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Aircraft[/TD]
[TD]Date[/TD]
[TD]Hours[/TD]
[TD]Seat[/TD]
[TD]Takeoff In "L" Seat?[/TD]
[TD]Landing In "L" Seat?[/TD]
[TD](IF T/O in L)[/TD]
[TD](IF Land in L)[/TD]
[/TR]
[TR]
[TD="align: right"]111[/TD]
[TD="align: right"]9/1/17[/TD]
[TD="align: right"]1[/TD]
[TD]L[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD="align: right"]9/1/17[/TD]
[TD="align: right"]9/1/17[/TD]
[/TR]
[TR]
[TD="align: right"]111[/TD]
[TD="align: right"]9/2/17[/TD]
[TD="align: right"]1[/TD]
[TD]L[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD="align: right"]9/2/17[/TD]
[TD="align: right"]9/2/17[/TD]
[/TR]
[TR]
[TD="align: right"]111[/TD]
[TD="align: right"]9/3/17[/TD]
[TD="align: right"]1.2[/TD]
[TD]L[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD="align: right"]9/3/17[/TD]
[TD="align: right"]9/3/17[/TD]
[/TR]
[TR]
[TD="align: right"]111[/TD]
[TD="align: right"]9/4/17[/TD]
[TD="align: right"]0.2[/TD]
[TD]R[/TD]
[TD]No[/TD]
[TD]Yes[/TD]
[TD][/TD]
[TD="align: right"]9/4/17[/TD]
[/TR]
[TR]
[TD="align: right"]111[/TD]
[TD="align: right"]9/5/17[/TD]
[TD="align: right"]1.6[/TD]
[TD]R[/TD]
[TD]No[/TD]
[TD]Yes[/TD]
[TD][/TD]
[TD="align: right"]9/5/17[/TD]
[/TR]
[TR]
[TD="align: right"]111[/TD]
[TD="align: right"]9/6/17[/TD]
[TD="align: right"]3.2[/TD]
[TD]L[/TD]
[TD]No[/TD]
[TD]Yes[/TD]
[TD][/TD]
[TD="align: right"]9/6/17[/TD]
[/TR]
[TR]
[TD="align: right"]111[/TD]
[TD="align: right"]9/7/17[/TD]
[TD="align: right"]1.2[/TD]
[TD]R[/TD]
[TD]Yes[/TD]
[TD]No[/TD]
[TD="align: right"]9/7/17[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]111[/TD]
[TD="align: right"]9/8/17[/TD]
[TD="align: right"]1[/TD]
[TD]L[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD="align: right"]9/8/17[/TD]
[TD="align: right"]9/8/17[/TD]
[/TR]
[TR]
[TD="align: right"]111[/TD]
[TD="align: right"]9/9/17[/TD]
[TD="align: right"]1.4[/TD]
[TD]L[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD="align: right"]9/9/17[/TD]
[TD="align: right"]9/9/17[/TD]
[/TR]
[TR]
[TD="align: right"]111[/TD]
[TD="align: right"]9/10/17[/TD]
[TD="align: right"]3[/TD]
[TD]L[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD="align: right"]9/10/17[/TD]
[TD="align: right"]9/10/17[/TD]
[/TR]
[TR]
[TD="align: right"]111[/TD]
[TD="align: right"]9/11/17[/TD]
[TD="align: right"]3.1[/TD]
[TD]R[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD="align: right"]9/11/17[/TD]
[TD="align: right"]9/11/17[/TD]
[/TR]
[TR]
[TD="align: right"]111[/TD]
[TD="align: right"]9/12/17[/TD]
[TD="align: right"]2[/TD]
[TD]R[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD="align: right"]9/12/17[/TD]
[TD="align: right"]9/12/17[/TD]
[/TR]
[TR]
[TD="align: right"]111[/TD]
[TD="align: right"]9/13/17[/TD]
[TD="align: right"]2.5[/TD]
[TD]L[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD="align: right"]9/13/17[/TD]
[TD="align: right"]9/13/17[/TD]
[/TR]
[TR]
[TD="align: right"]111[/TD]
[TD="align: right"]9/14/17[/TD]
[TD="align: right"]2.7[/TD]
[TD]R[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD="align: right"]9/14/17[/TD]
[TD="align: right"]9/14/17[/TD]
[/TR]
[TR]
[TD="align: right"]111[/TD]
[TD="align: right"]9/15/17[/TD]
[TD="align: right"]5[/TD]
[TD]R[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD="align: right"]9/15/17[/TD]
[TD="align: right"]9/15/17[/TD]
[/TR]
</tbody>[/TABLE]
What I'm trying to get is the latest Takeoff and Latest landing ONLY From the "L" Seat. Sum hours is easy, but I cant seem to get the last takeoff and landing of this particular sheet. The information is autopouplated, and isn't always in order, so I've had issue with the sort function. Please Help! THANKS!!!
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>[TABLE="width: 0"]
<colgroup><col style="width: 113px"><col width="147"><col width="170"></colgroup><tbody>[TR]
[TD]Hours This Month[/TD]
[TD]Last Takeoff ThisMonth[/TD]
[TD]Latest Landing This Month[/TD]
[/TR]
[TR]
[TD="align: right"]30.1[/TD]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
</tbody>[/TABLE]