Hi All:
The goal here is to be provided with a workflow that identifies suppliers who have submitted invoices within a short period of time.
Short period of time = number of days between the invoices do not exceed 5 days (good example is Transaction ID # 1 through 5 - please see below table where you will notice that the invoice dates are back to back).
The file I have contains more than 300,000 lines with different suppliers and different invoice date, number and amounts. However, I would like to highlight all invoices provided that falls within short period of time.
Thank you in advance.
| Transaction ID # | Supplier name | Invoice # | Invoice date |
| 1 | A | 10 | Jan 1 2021 |
| 2 | A | 20 | Jan 1 2021 |
| 3 | A | 30 | Jan 2 2021 |
| 4 | A | 40 | Jan 3 2021 |
| 5 | A | 50 | Jan 4 2021 |
| 6 | A | 60 | Feb 15 2021 |
| 7 | A | 70 | March 30 2021 |
| 8 | B | 80 | April 5 2021 |
| 9 | C | 90 | May 10 2021 |
