Spreadsheet: 584266d1533066204-need-help-to-find-the-previous-record-support_new-repir
Sheet: Sheet6

Raw Data |  |  |  |  |  |  |  | Desired Result
Serial Number | Received date | Finished date | Repair Status | Techncian | Repeated status |  |  | Serial Number | Received date | Finished date | Repair Status | Number of dates between previous repair | Repeated status | Previos repair done by
105111 | 2018-05-01 00:00:00 | 2018-05-04 00:00:00 | Completed | [NAME] | No |  |  | 105111 | 2018-05-01 00:00:00 | 2018-05-04 00:00:00 | Completed | 0 | No
232842 | 2018-05-01 00:00:00 | 2018-05-04 00:00:00 | Completed | Mark | No |  |  | 232842 | 2018-05-01 00:00:00 | 2018-05-04 00:00:00 | Completed | 0 | No
738 | 2018-05-01 00:00:00 | 2018-05-04 00:00:00 | Completed | [NAME] | No |  |  | 738 | 2018-05-01 00:00:00 | 2018-05-04 00:00:00 | Completed | 0 | No
738 | 2018-05-07 00:00:00 | 2018-05-10 00:00:00 | Cancelled | Subert | Yes |  |  | 738 | 2018-05-07 00:00:00 | 2018-05-10 00:00:00 | Cancelled | 3 | Yes | [NAME]
144923 | 2018-05-07 00:00:00 | 2018-05-10 00:00:00 | Completed | Mark | No |  |  | 144923 | 2018-05-07 00:00:00 | 2018-05-10 00:00:00 | Completed | 0 | No
738 | 2018-05-15 00:00:00 | 2018-05-18 00:00:00 | Completed | Mark | No |  |  | 738 | 2018-05-15 00:00:00 | 2018-05-18 00:00:00 | Completed | 5 | No
885 | 2018-05-15 00:00:00 | 2018-05-18 00:00:00 | Cancelled | [NAME] | No |  |  | 885 | 2018-05-15 00:00:00 | 2018-05-18 00:00:00 | Cancelled | 0 | No
127809 | 2018-05-16 00:00:00 | 2018-05-19 00:00:00 | Completed | Ruel | No |  |  | 127809 | 2018-05-16 00:00:00 | 2018-05-19 00:00:00 | Completed | 0 | No
128198 | 2018-05-16 00:00:00 | 2018-05-19 00:00:00 | Completed | [NAME] | No |  |  | 128198 | 2018-05-16 00:00:00 | 2018-05-19 00:00:00 | Completed | 0 | No
114002 | 2018-05-17 00:00:00 | 2018-05-20 00:00:00 | Completed | Ruel | No |  |  | 114002 | 2018-05-17 00:00:00 | 2018-05-20 00:00:00 | Completed | 0 | No
8295 | 2018-05-20 00:00:00 | 2018-05-23 00:00:00 | Completed | [NAME] | No |  |  | 8295 | 2018-05-20 00:00:00 | 2018-05-23 00:00:00 | Completed | 0 | No
885 | 2018-05-26 00:00:00 | 2018-05-29 00:00:00 | Completed | Subert | No |  |  | 885 | 2018-05-26 00:00:00 | 2018-05-29 00:00:00 | Completed | 8 | No
1880 | 2018-05-26 00:00:00 | 2018-05-29 00:00:00 | Cancelled | [NAME] | No |  |  | 1880 | 2018-05-26 00:00:00 | 2018-05-29 00:00:00 | Cancelled | 0 | No
509180 | 2018-05-28 00:00:00 | 2018-05-31 00:00:00 | Cancelled | Mark | No |  |  | 509180 | 2018-05-28 00:00:00 | 2018-05-31 00:00:00 | Cancelled | 0 | No
1880 | 2018-06-05 00:00:00 | 2018-06-08 00:00:00 | Completed | Subert | No |  |  | 1880 | 2018-06-05 00:00:00 | 2018-06-08 00:00:00 | Completed | 7 | No
85099 | 2018-06-12 00:00:00 | 2018-06-15 00:00:00 | Cancelled | [NAME] | No |  |  | 85099 | 2018-06-12 00:00:00 | 2018-06-15 00:00:00 | Cancelled | 0 | No
8297 | 2018-06-13 00:00:00 | 2018-06-16 00:00:00 | Cancelled | [NAME] | No |  |  | 8297 | 2018-06-13 00:00:00 | 2018-06-16 00:00:00 | Completed | 0 | No
32549 | 2018-06-14 00:00:00 | 2018-06-17 00:00:00 | Completed | [NAME] | No |  |  | 32549 | 2018-06-14 00:00:00 | 2018-06-17 00:00:00 | Completed | 0 | No
32547 | 2018-06-14 00:00:00 | 2018-06-17 00:00:00 | Completed | Subert | Yes |  |  | 738 | 2018-06-14 00:00:00 | 2018-06-17 00:00:00 | Completed | 27 | Yes | Mark
104469 | 2018-06-26 00:00:00 | 2018-06-29 00:00:00 | Completed | [NAME] | No |  |  | 104469 | 2018-06-26 00:00:00 | 2018-06-29 00:00:00 | Completed | 0 | No
1880 | 2018-06-30 00:00:00 | 2018-07-03 00:00:00 | Completed | Ruel | Yes |  |  | 1880 | 2018-06-30 00:00:00 | 2018-07-03 00:00:00 | Completed | 22 | Yes | Subert
81999 | 2018-07-05 00:00:00 | 2018-07-08 00:00:00 | Completed | Ruel | No |  |  | 81999 | 2018-07-05 00:00:00 | 2018-07-08 00:00:00 | Completed | 0 | No
126745 | 2018-07-12 00:00:00 | 2018-07-15 00:00:00 | Completed | [NAME] | No |  |  | 126745 | 2018-07-12 00:00:00 | 2018-07-15 00:00:00 | Completed | 0 | No
8297 | 2018-07-18 00:00:00 | 2018-07-21 00:00:00 | Completed | [NAME] | No |  |  | 8297 | 2018-07-18 00:00:00 | 2018-07-21 00:00:00 | Completed | 32 | No
608000040 | 2018-07-25 00:00:00 | 2018-07-28 00:00:00 | Completed | Ruel | No |  |  | 608000040 | 2018-07-25 00:00:00 | 2018-07-28 00:00:00 | Completed | 0 | No
11522 | 2018-07-26 00:00:00 | 2018-07-29 00:00:00 | Completed | Mark | No |  |  | 11522 | 2018-07-26 00:00:00 | 2018-07-29 00:00:00 | Completed | 0 | No
10004 | 2018-08-12 00:00:00 | 2018-08-15 00:00:00 | Completed | [NAME] | Yes |  |  | 885 | 2018-08-12 00:00:00 | 2018-08-15 00:00:00 | Completed | 75 | Yes | Subert