Spreadsheet: 826455d1682017104-highlight-duplicate-rows-for-an-action-number-highlight-double-steps
Sheet: Double Steps

TASK:  Rows 3 to 11 show the result required where each Action Number (column A) has a duplicate Step Code (column D) with same Role (column H)
Action No. | Action Status | Date Submitted | Step Code | Code) Start Date | Code) End Date | [NAME] | [NAME]
26878 | In Progres | 2019-08-26 00:00:00 | 100 | 2019-08-23 00:00:00 | 2019-08-23 00:00:00 | Request Received and Verified | With HR Assistant
26878 | In Progres | 2019-08-26 00:00:00 | 55555 | 2019-08-23 00:00:00 | 2019-08-23 00:00:00 | On Hold | With Manager
26878 | In Progres | 2019-08-26 00:00:00 | 55555 | 2019-08-23 00:00:00 | 2019-08-23 00:00:00 | On Hold | With Manager
26878 | In Progres | 2019-08-26 00:00:00 | 55555 | 2019-08-23 00:00:00 | 2019-08-26 00:00:00 | On Hold | With Manager
26878 | In Progres | 2019-08-26 00:00:00 | 100 | 2019-08-26 00:00:00 | 2019-08-26 00:00:00 | Request Received and Verified | With HR Assistant
26878 | In Progres | 2019-08-26 00:00:00 | 220 |  |  | Produce Letter of Offer | With HR Assistant
26878 | In Progres | 2019-08-26 00:00:00 | 230 |  |  | Send Manager Letter of Offer | With HR Assistant
26878 | In Progres | 2019-08-26 00:00:00 | 240 |  |  | Receive signed Letter of Offer | With HR Assistant
26878 | In Progres | 2019-08-26 00:00:00 | 270 |  |  | PS Job Data Entry | With HR Assistant
27834 | In Progres | 2019-09-20 00:00:00 | 100 | 2019-09-19 00:00:00 | 2019-09-20 00:00:00 | Request Received and Verified | With HR Assistant
27834 | In Progres | 2019-09-20 00:00:00 | 55555 | 2019-09-20 00:00:00 | 2019-09-20 00:00:00 | On Hold | With Manager
27834 | In Progres | 2019-09-20 00:00:00 | 100 | 2019-09-20 00:00:00 | 2019-09-20 00:00:00 | Request Received and Verified | With HR Assistant
27834 | In Progres | 2019-09-20 00:00:00 | 220 |  |  | Produce Letter of Offer | With HR Assistant
27834 | In Progres | 2019-09-20 00:00:00 | 230 |  |  | Send Manager Letter of Offer | With HR Assistant
27834 | In Progres | 2019-09-20 00:00:00 | 240 |  |  | Receive signed Letter of Offer | With HR Assistant
27834 | In Progres | 2019-09-20 00:00:00 | 270 |  |  | PS Job Data Entry | With HR Assistant
125692 | In Progres | 2023-03-10 00:00:00 | 100 | 2023-03-10 00:00:00 | 2023-03-10 00:00:00 | Request Received and Verified | With HR Assistant
125692 | In Progres | 2023-03-10 00:00:00 | 200 |  |  | Post NOC | With HR Assistant
125692 | In Progres | 2023-03-10 00:00:00 | 205 |  |  | Post NAPA | With HR Assistant
125692 | In Progres | 2023-03-10 00:00:00 | 220 | 2023-03-10 00:00:00 | 2023-03-10 00:00:00 | Produce Letter of Offer | With HR Assistant
125692 | In Progres | 2023-03-10 00:00:00 | 230 |  |  | Send Manager Letter of Offer | With Advisor
125692 | In Progres | 2023-03-10 00:00:00 | 240 |  |  | Receive signed Letter of Offer | With HR Assistant
125692 | In Progres | 2023-03-10 00:00:00 | 270 |  |  | PS Job Data Entry | With HR Assistant
125699 | In Progres | 2023-04-03 00:00:00 | 100 | 2023-03-29 00:00:00 | 2023-04-03 00:00:00 | Request Received and Verified | With HR Assistant
125699 | In Progres | 2023-04-03 00:00:00 | 55555 | 2023-04-03 00:00:00 | 2023-04-03 00:00:00 | On Hold | With Manager
125699 | In Progres | 2023-04-03 00:00:00 | 100 | 2023-04-03 00:00:00 | 2023-04-05 00:00:00 | Request Received and Verified | With HR Assistant
125699 | In Progres | 2023-04-03 00:00:00 | 250 |  |  | PS Data Entry ACT,ASG, SEC | With HR Assistant
125716 | In Progres | 2023-03-10 00:00:00 | 100 | 2023-03-23 00:00:00 | 2023-03-23 00:00:00 | Request Received and Verified | With HR Assistant
125716 | In Progres | 2023-03-10 00:00:00 | 200 | 2023-03-23 00:00:00 | 2023-03-29 00:00:00 | Post NOC | With HR Assistant
125716 | In Progres | 2023-03-10 00:00:00 | 205 | 2023-03-31 00:00:00 | 2023-04-17 00:00:00 | Post NAPA | With HR Assistant
125716 | In Progres | 2023-03-10 00:00:00 | 220 | 2023-03-27 00:00:00 | 2023-03-31 00:00:00 | Produce Letter of Offer | With HR Assistant
125716 | In Progres | 2023-03-10 00:00:00 | 230 | 2023-03-27 00:00:00 | 2023-03-31 00:00:00 | Send Manager Letter of Offer | With Advisor
125716 | In Progres | 2023-03-10 00:00:00 | 240 |  |  | Receive signed Letter of Offer | With HR Assistant
125716 | In Progres | 2023-03-10 00:00:00 | 270 |  |  | PS Job Data Entry | With HR Assistant
125732 | In Progres | 2023-03-14 00:00:00 | 100 | 2023-03-10 00:00:00 | 2023-03-13 00:00:00 | Request Received and Verified | With HR Assistant
125732 | In Progres | 2023-03-14 00:00:00 | 55555 | 2023-03-13 00:00:00 | 2023-03-14 00:00:00 | On Hold | With Manager
125732 | In Progres | 2023-03-14 00:00:00 | 100 | 2023-03-14 00:00:00 | 2023-03-22 00:00:00 | Request Received and Verified | With HR Assistant
125732 | In Progres | 2023-03-14 00:00:00 | 260 | 2023-03-28 00:00:00 |  | TIN Action Confirm | With HR Assistant
125732 | In Progres | 2023-03-14 00:00:00 | 220 |  |  | Produce Letter of Offer | With HR Assistant
125732 | In Progres | 2023-03-14 00:00:00 | 230 |  |  | Send Manager Letter of Offer | With HR Assistant
125732 | In Progres | 2023-03-14 00:00:00 | 240 |  |  | Receive signed Letter of Offer | With HR Assistant
125732 | In Progres | 2023-03-14 00:00:00 | 270 |  |  | PS Job Data Entry | With HR Assistant