Forum Discussion

BEN_FAWKES's avatar
BEN_FAWKES
Copper Contributor
Mar 07, 2020
Solved

Pilot Logbook

Aircraft Logbook Column has column of aircraft Registrations G-TUIA to G-TUIJ. Types TUIA to TUII are type 787-8 and TUIJ to TUIN are type 787-9. When I type in the registration, how do i get the ne...
excel
  • ExcelExciting's avatar
    ExcelExciting
    Mar 07, 2020

    HI BEN_FAWKES 

     

    Make the master table where you have aircraft registration at one place, as per below image 

     

    I'm also attaching the excel for your easy reference 

     

    Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

    If you find the above solution resolved your query don't forget mark as Official Answer. 

     

     

ExcelExciting's avatar
ExcelExciting
MVP
Mar 07, 2020

HI BEN_FAWKES 

 

Make the master table where you have aircraft registration at one place, as per below image 

 

I'm also attaching the excel for your easy reference 

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer. 

 

 

BEN_FAWKES's avatar
BEN_FAWKES
Copper Contributor
Mar 10, 2020

MANY THANKS. ALL SORTED. YOU ARE A STAR 😉ExcelExciting 

  • ExcelExciting's avatar
    ExcelExciting
    MVP
    Mar 10, 2020

    BEN_FAWKES Happy to hear your query was resolve 😃👍

     

    Regards, Faraz Shaikh