I have a running report(example report link below) that lists accounts that are/will be overdrawn. Therefore, need cash deposited to the account. If the Execute column is checked then it should be included in the count. If the Do Not Execute column is checked or neither column is checked then it need to refer to the date. Basically, I need to count each instance while excluding the duplicates. I have manually input a count column.
Here are my examples.
Example 1: I want to count the first instance for Taylor that occurred 1/5/23. And because nothing was executed, the account continues to appear on the following business days reports. I do not want these counted since they are duplicates. (It doesn't matter which instance is counted; I just need these 3 to count as 1)
Example 2: No action was taken the first time this account appeared on the report. Action was take the second time it appeared. I want to count only the instance where action was taken.
Example 3: This account appears twice. Once at the beginning of the month and once towards the middle of the month. I want to count both of these instances since they are not duplicates.
Example 4: These accounts only appeared once. I want them counted regardless of the action.
I'm stumped on how to accomplish this one. Any help is appreciated!
Brittany
