Pick and display the right number using different match criterias.

  • 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: https://www.dropbox.com/s/cr17…Skema_Siemens_23.zip?dl=0
    Thank you so much!!!

  • Re: Pick and display the right number using different match criterias.


    Did you try to compress the file to a .zip or shrink the file by removing unnecessary worksheets, or data before uploading?


    Failing that, use DropBox or similar to create a link to the file for review.

    Where there is a will there are many ways. Finding one that works for you is the challenge!


    MS Excel MVP 2010-2016