Forum Discussion
Solved
days since last accident
Can someone help me with a formula which provides the days since last accident with a fatality. Above in Columns B-I I have data for the given event, what I need is for the filled in sectio...
=$G$2-LARGE(IF((Table1[Fatality]=1)*(Table1[Accident type]=H$1),Table1[Accident date]),1)You can try this formula which takes the types of accidents into account. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021. To simplify the solution i'd recommend to combine all four sheets into one. In this example the data is in a dynamic table and therefore all added records are included in the calculation automatically.
=$G$2-LARGE(IF((Table1[Fatality]=1)*(Table1[Accident type]=H$1),Table1[Accident date]),1)You can try this formula which takes the types of accidents into account. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021. To simplify the solution i'd recommend to combine all four sheets into one. In this example the data is in a dynamic table and therefore all added records are included in the calculation automatically.
Thank you all for your responses, you have helped me tremendously. I am trying to take some courses through Udemy online in order to learn excel a little better (actually a lot), time will tell.