Good afternoon, everybody.
I created a game-like spreadsheet for fictional airline network scheduling as a practice in Excel. Currently I am struggling with creating a visual representation of daily flight schedule, consisting of airframe registrations in columns and time in rows- what I have and what I want to obtain is shown on the screens below:
Flight Schedule / FLTSCH Table:
asfdasf.png
Flight List / FLTLST Table:
2021_01_04_14_33_03_Window.png
The goal:
2021_01_04_14_21_38_Window.png
I tried to adjust the original MS "summer schedule" template for this purpose, but unfortunately failed. The formula I am stuck with is as follows:
=IFERROR(INDEX(FLTLST,MATCH(SUMPRODUCT((FLTLST[REG]=FLTSCHED[[#Headers],[TF-FIB]])*(ROUNDDOWN($G7,10)>=ROUNDDOWN(FLTLST[DEP],10))*($G7<=FLTLST[ARR]),FLTLST[UNIQUE]),FLTLST[UNIQUE],0),2),0)
Do somebody have an idea, what mistake do I make that Sumproduct function does not work?
Bookmarks