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...
Here is a formula solution that should work in all versions of Excel. If you have Microsoft 365, you could use the UNIQUE function to extract the unique route numbers instead.