Formula to determine how many times something occurred in a row
For my business I have multiple trucks, and every morning we record the statuses of the trucks before they start driving. I have multiple columns, each one being the different trucks. In the rows for those trucks I record the statuses for the different trucks. So I have "Available","Breakdown" etc.
I'm trying to write a formula in which I see how many days in a row that Truck has had that status for from the most recent date. Would someone please be able to assist with this?