Conditional Ranking of Cell values

[ajhavery]

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.

 

[ajhavery]

I'm unable to add screenshot in the above post.

The below link has the screenshot. Apologies for the issue.

https://ibb.co/eWvmdw

 

[Marcelo Branco]

An image isn't helpful - is not possible to copy/paste for testing purposes
Try to post in the thread a data sample - see section B in
https://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html

M.