I have this records below
If the “PROJECT_NUMBER” is repeated AND “INCIDENT_CREATION_DATE” between the two incidents is less than 31 days then mark it as a "repeat"
I am confused as how shall I do it, as did countif as well to find the duplicate and then the diff in date but the records can be in any row.
<tbody>
</tbody>
If the “PROJECT_NUMBER” is repeated AND “INCIDENT_CREATION_DATE” between the two incidents is less than 31 days then mark it as a "repeat"
I am confused as how shall I do it, as did countif as well to find the duplicate and then the diff in date but the records can be in any row.
INCIDENT_ID | INCIDENT_CREATION_DATE | PROJECT_NUMBER | Result |
136672962 | 02-11-2019 09:51:01 | 112298608 | Repeat |
136672522 | 02-11-2019 09:51:01 | 112298601 | |
136672581 | 02-11-2019 09:51:01 | 112298602 | |
136672969 | 02-12-2019 09:51:01 | 112298608 | |
136672991 | 02-10-2019 09:51:01 | 112298690 | |
136672999 | 02-11-2019 09:51:01 | 112298661 | Repeat |
136672810 | 02-11-2019 09:51:01 | 112298685 | |
1366721010 | 02-15-2019 09:51:01 | 112298661 |
<tbody>
</tbody>