Forum Discussion
Creating an IF statement using the previous cell as reference to keep track of different departures
Hi Anonymous ,
Don't seem to understand your requirements, can you explain the relationship between the PLATE, DIRECTION and ROUTE fields and the desired screenshot of the results?
Looking forward to your reply.
Best Regards,
Henry
Plate is the license plate for the bus.
Direction is which way the bus is going. Either from point a A to point B or from point B to point A. There are busses that do multiple trips of each direction which is why I can't just use that so sepparate them.
Route you can ignore since I'm only working with the data from one specific route, meaning it's the same in every entry. Same with Description.
Also another caveat is that the busses don't all make the same stops each trip. They change depending on where people need to board or get off. They are also string data with no clear indication as to the order they're in. There is a timestamp on each entry though that I just realized I accidentally left out in the table earlier.