I have a master file with over 5k records to keep track of assignments. In this file new records keep getting added on a bi-weekly basis.
Each person that's listed in the file has a Unique ID, and a date that the assignment was assigned. You can only receive 1 assignment every 14 days. I need a conditional format or something to indicate if anyone received more than one assignment in a 2 week period at any point and moving forward.
Keep in mind each person might be on this list more than 10 times.
Thanks in advance.
Each person that's listed in the file has a Unique ID, and a date that the assignment was assigned. You can only receive 1 assignment every 14 days. I need a conditional format or something to indicate if anyone received more than one assignment in a 2 week period at any point and moving forward.
Keep in mind each person might be on this list more than 10 times.
Thanks in advance.