Posts by AntoAnto

    Hi there,

    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:…
    Thank you so much!!!