I'm working on a data set as displayed below.
I need to Index the maintenance and breakdown schedule of few equipment. The screenshot below displays the data for 2 equipment (Column G) with their maintenance schedule.
Column A & B lists the Start date and time of maintenance/breakdown, Column C & D lists the completion date and time of Maintenance/Breakdown. I need to fill in the data in last 2 columns for Index of Maintenance & Breakdown for 2 equipment LPDT 65 and 66 (Column G).
The data in Column N and O are filled as per below logic. For each Equip # (Column G), If Column M is "PM" and Column E is "Not repeated", Increase Maintenance # by 1.
Similarly for Column O, For each Equip # (Column G), If Column M is "BD" and Column E is "Not repeated", Increase Breakdown # by 1.
I've attached the file for reference. Please find below a screenshot of data.
[ATTACH=JSON]{"data-align":"none","data-size":"large","data-attachmentid":1193727}[/ATTACH] I've also asked this question at: http://%22https//www.mrexcel.c…ditions.html%22