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.
[TABLE="width: 500"]
<tbody>[TR]
[TD]INCIDENT_ID[/TD]
[TD]INCIDENT_CREATION_DATE[/TD]
[TD]PROJECT_NUMBER[/TD]
[TD]Result[/TD]
[/TR]
[TR]
[TD]136672962[/TD]
[TD]02-11-2019 09:51:01[/TD]
[TD]112298608[/TD]
[TD]Repeat[/TD]
[/TR]
[TR]
[TD]136672522[/TD]
[TD]02-11-2019 09:51:01[/TD]
[TD]112298601[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]136672581[/TD]
[TD]02-11-2019 09:51:01[/TD]
[TD]112298602[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]136672969[/TD]
[TD]02-12-2019 09:51:01[/TD]
[TD]112298608[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]136672991[/TD]
[TD]02-10-2019 09:51:01[/TD]
[TD]112298690[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]136672999[/TD]
[TD]02-11-2019 09:51:01[/TD]
[TD]112298661[/TD]
[TD]Repeat[/TD]
[/TR]
[TR]
[TD]136672810[/TD]
[TD]02-11-2019 09:51:01[/TD]
[TD]112298685[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1366721010[/TD]
[TD]02-15-2019 09:51:01[/TD]
[TD]112298661[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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.
[TABLE="width: 500"]
<tbody>[TR]
[TD]INCIDENT_ID[/TD]
[TD]INCIDENT_CREATION_DATE[/TD]
[TD]PROJECT_NUMBER[/TD]
[TD]Result[/TD]
[/TR]
[TR]
[TD]136672962[/TD]
[TD]02-11-2019 09:51:01[/TD]
[TD]112298608[/TD]
[TD]Repeat[/TD]
[/TR]
[TR]
[TD]136672522[/TD]
[TD]02-11-2019 09:51:01[/TD]
[TD]112298601[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]136672581[/TD]
[TD]02-11-2019 09:51:01[/TD]
[TD]112298602[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]136672969[/TD]
[TD]02-12-2019 09:51:01[/TD]
[TD]112298608[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]136672991[/TD]
[TD]02-10-2019 09:51:01[/TD]
[TD]112298690[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]136672999[/TD]
[TD]02-11-2019 09:51:01[/TD]
[TD]112298661[/TD]
[TD]Repeat[/TD]
[/TR]
[TR]
[TD]136672810[/TD]
[TD]02-11-2019 09:51:01[/TD]
[TD]112298685[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1366721010[/TD]
[TD]02-15-2019 09:51:01[/TD]
[TD]112298661[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]