Forum Discussion
Need help to check whether it is dual depot
Hi, I need some help regarding the excel format. So I am trying to divide the route into either single or dual depot. For example, in the excel sheet given, for route 8, there are 3 bus depots th...
evilgreenred A not very elegant, but rather simple way would be to create a pivot table and count the number of Depots on a Route. One occurrence returns "Single", anything greater than one returns "Dual".