My data consist of records with Incident Numbers. Within these incident records are several trucks with a response time attached to each truck:
Incident Number - 160039
Truck - E34 ____ Response - 2.85
Truck - E35 ____ Response - 2.83
Truck - T34 ____ Response - 6.30
Truck - A35 ____ Response - 3.34
Incident Number - 160423
Truck - E34 ____ Response - 4.21
Truck - E35 ____ Response - 3.55
Truck - T34 ____ Response - 3.19
Truck - A35 ____ Response - 5.62
I need to report on the second fastest truck. For example:
Incident Number 160039
Truck E34 - Response 2.85
Incident Number 160423
Truck E35 - Response 3.55
How can I accomplish this?
Incident Number - 160039
Truck - E34 ____ Response - 2.85
Truck - E35 ____ Response - 2.83
Truck - T34 ____ Response - 6.30
Truck - A35 ____ Response - 3.34
Incident Number - 160423
Truck - E34 ____ Response - 4.21
Truck - E35 ____ Response - 3.55
Truck - T34 ____ Response - 3.19
Truck - A35 ____ Response - 5.62
I need to report on the second fastest truck. For example:
Incident Number 160039
Truck E34 - Response 2.85
Incident Number 160423
Truck E35 - Response 3.55
How can I accomplish this?