Is there a way to find duplicate entries over a rolling number of days? For example, I have a date in one field and a name in another field. If that name were to re-appear within X number of days, then I would like to flag those entries.
For example, let's say I enter "John Smith" on 1/9 and let's also say that my range is 5 days. If his name appears again on 1/12, I would want both entries to be flagged.
I would be working off of two fields. A date field and a name field. The trick is that I need it to be a rolling date range.
I've been using Excel for close to a decade but in all of that time, I've just done the basics with it.
Any help that can be offered will be greatly appreciated. Thanks in advance.
Bookmarks