bijufrancis
New Member
Hi,
In the attached file 1st Column are the vehicle numbers. The ROW provides the detail of the payment made each day through different modes through out a month. Digit 9 is the number which represents the vehicle has not paid and gone free.
I want to find the following:
1. the first three trips for the whole month wherein the vehicle has paid consequently 3 times.
2. In case the vehicle has not paid in the 2nd or 3rd time should be shown in Day 2 or Day 3.
In the attached file 1st Column are the vehicle numbers. The ROW provides the detail of the payment made each day through different modes through out a month. Digit 9 is the number which represents the vehicle has not paid and gone free.
I want to find the following:
1. the first three trips for the whole month wherein the vehicle has paid consequently 3 times.
2. In case the vehicle has not paid in the 2nd or 3rd time should be shown in Day 2 or Day 3.