Hey Everyone . . .
Looking for some assistance on a formula or VBA. I have the below dataset and I am trying to automate the calculation of the running total. Basically, I need it to say, if the user stays the same, the processID stays the same, the client id is new, and the closed column is 0 the increment my running total. But if the same client comes up (row 4 for example) I don't want to increment my running total. Also, if closed is equal to 1 I need to decrease the running total appropriately, so for the first 3 rows I see the total go from 0 to 1 to 2 to 3, but on the third row they closed, so I need to the running total at 2. Thoughts?
thanks!
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
Looking for some assistance on a formula or VBA. I have the below dataset and I am trying to automate the calculation of the running total. Basically, I need it to say, if the user stays the same, the processID stays the same, the client id is new, and the closed column is 0 the increment my running total. But if the same client comes up (row 4 for example) I don't want to increment my running total. Also, if closed is equal to 1 I need to decrease the running total appropriately, so for the first 3 rows I see the total go from 0 to 1 to 2 to 3, but on the third row they closed, so I need to the running total at 2. Thoughts?
thanks!
User | Closed | ClientID | processID | Running Total |
User1 | 0 | 8753053 | 8696 | 1 |
User1 | 0 | 10193883 | 8696 | 2 |
User1 | 1 | 4905128 | 8696 | 2 |
User1 | 0 | 10193883 | 8696 | 2 |
User1 | 1 | 6738817 | 8696 | 2 |
User1 | 1 | 10193883 | 8696 | 1 |
User1 | 0 | 10193883 | 8696 | 1 |
User1 | 0 | 10066793 | 8696 | 2 |
User1 | 1 | 10066793 | 8696 | 1 |
User1 | 1 | 10193883 | 8696 | 0 |
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>