Vehicle rotation count

[anu0512]

Hi,

I want to know in a day & month a vehicle doing how many trips. Basically rotation of the vehicle.

Abbreviation codes:

Driver Code
GU- Gurdeep
G- Gafar

G1- It will show the that driver done the multi delivery in this trip.

For Example- On 2 June Gafar driver done four trips (G1 to G4) but if you see the same vehicle DXB-81119 in G1 trip has been used in G3 trip DXB-81119, so this day the same vehicle done the two trips. So I want know in day and month a all vehicle is doing how many trips. The only unique thing is vehicle number.

https://ufile.io/jphzbpph​

 

[Fluff]

Cross posted https://www.excelforum.com/excel-general/1287427-vehicle-rotation-count.html#post5181530

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.