Spreadsheet: 814520d1674467767-lookup-previous-occurences-of-a-value-in-a-column-and-calculate-number-of-days-between-row-sample7
Sheet: Sheet1

Machine Profile Name | Work Order Number | Appointment Number | Assigned Resource Number | Machine ID | Serial Number | Work Order ID | Work Type: Work Type Name | Work Type Indicator | Work Type: Work Type Name | Service Appointment ID | Service Territory: Name | Service Resource: Name | Travelling Start | Travelling End | Travelling Time (Minutes) | Machine Description | Machine Brand | Machine Type | Machine Installation Date | Actual Start | Created Date & Time | Actual End | Duration in Minutes | Actual Completion Days | Status | Months from Installation Date | Reason For No Intervention | Country | Created Date | Month | Created Date (Formatted) | End Date (Formatted) | Arrive Date (Formatted) | Customer E2E (Days) | Internal Response Time (Hours) | Internal Response Time |  | 90 Day Repeat? | E2E
sample | sample | sample | sample | sample | 15021170 | sample | UK Repair Medium | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | 2022-09-30 00:00:00 | sample | sample | sample | sample | 0.03819444444525288 | 1 | 0:55:00 |  |  | 0:55:00
sample | sample | sample | sample | sample | 15021170 | sample | UK Preventative Maintenance Medium | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | 2022-10-13 00:00:00 | sample | sample | sample | sample |  |  |  |  |  | #[NAME]!
sample | sample | sample | sample | sample | 15021170 | sample | UK Preventative Maintenance Low | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | 2022-10-25 00:00:00 | sample | sample | sample | sample | 0.02430555555474712 | 1 | 0:35:00 |  |  | 0:35:00
sample | sample | sample | sample | sample | 15021170 | sample | UK Revisit Very High | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | 2022-11-04 00:00:00 | sample | sample | sample | sample | 0.07847222221607808 | 1 | 1:52:00 |  |  | 1:53:00
sample | sample | sample | sample | sample | 15021170 | sample | UK Repair Medium XX | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | 2022-11-10 00:00:00 | sample | sample | sample | sample | 0.1319444444379769 | 1 | 0:19:00 |  |  | 3:10:00
sample | sample | sample | sample | sample | 15021170 | sample | UK Repair Medium | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | 2022-11-25 00:00:00 | sample | sample | sample | sample | 0.06111111110658385 | 1 | 1:24:00 |  |  | 1:28:00
sample | sample | sample | sample | sample | 15021170 | sample | FR Client Care Low | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | sample | 2022-11-29 00:00:00 | sample | sample | sample | sample | 1.731944444443798 | 3 | 10:06:00 |  |  | 10:34:00
 |  |  |  |  |  |  |  |  |  |  |  |  | UK Repair Medium
 |  |  |  |  |  |  |  |  |  |  |  |  | UK Revisit Medium
 |  |  |  |  |  |  |  |  |  |  |  |  | UK Repair High
 |  |  |  |  |  |  |  |  |  |  |  |  | UK Revisit High
 |  |  |  |  |  |  |  |  |  |  |  |  | UK Repair High XX
 |  |  |  |  |  |  |  |  |  |  |  |  | UK Revisit High XX
 |  |  |  |  |  |  |  |  |  |  |  |  | UK Repair Very High
 |  |  |  |  |  |  |  |  |  |  |  |  | UK Revisit Very High XX
 |  |  |  |  |  |  |  |  |  |  |  |  | UK Repair Very High XX
 |  |  |  |  |  |  |  |  |  |  |  |  | UK Revisit Very High