Dear All
I have attached the sample data sheet along with the desired result wish to
achieve. second page is having the actual repair records which i need to apply the formula.
what want to find as follows.
when any serial number comes to service, the formula should look in to repair history of that serial number. if there is any previous record(S) relates to respective serial number, formula should calculate the number of date between the recieved date and the previous finished date with one conditon. repair stutus of previous repair equal to Completed, then Repeated status should be "Yes", if repair status equal to "cancelled" repeated status should be "No"
Serial Number- Received date- Finished date- Repair Status- # of dates between previous repair- Repeated status
738 5/1/2018 5/4/2018 Completed 0 No
738 5/7/2018 5/10/2018 Cancelled 3 Yes
738 5/15/2018 5/18/2018 Completed 5 No
885 5/15/2018 5/18/2018 Cancelled 0 No
885 5/26/2018 5/29/2018 Completed 8 No
885 8/12/2018 8/15/2018 Completed 75 Yes
Bookmarks