I have a list of trains (see."input" sheet) and I want to display them on a timeline graph which goes from Sunday to Saturday on a different sheet (see "output" sheet, only the top part until row 53).
I managed to display the number "1" every time the formula recognise there is a train on that specific day, at that specific time and on the specific locomotive type (e.g EG which stands for electric).
I would also like to display the train number but the COUNTIFS formula I made does not work properly. The trains displayed are mixed up and do not correspond with the ones on the list. I think the formula does not match the right locomotive types.
The excel file I am using is old and it has been used by many people so maybe there is something wrong with the formulas.
Can any of you help, please?
P.s: here the file: https://www.dropbox.com/s/cr17…Skema_Siemens_23.zip?dl=0
Thank you so much!!!