I'm working on a data set as displayed below.
I need to rank the maintenance and breakdown schedule of few equipment. The screenshot displays the data for 2 equipment with their maintenance schedule.
Column 1&2 lists the Start date and time, Column 3&4 lists the completion date and time of Maintenance/Breakdown. I need to fill in the data in last 2 columns for
rank 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.
Kindly help me how I can do this in excel without VBA code.
I need to rank the maintenance and breakdown schedule of few equipment. The screenshot displays the data for 2 equipment with their maintenance schedule.
Column 1&2 lists the Start date and time, Column 3&4 lists the completion date and time of Maintenance/Breakdown. I need to fill in the data in last 2 columns for
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.
Kindly help me how I can do this in excel without VBA code.