Hello all,
I've got a pivot that is providing me with the number of times a rep has backdated an account. I have been unable to find the right formula to capture any months where there has been backdating done multiple times within the same month. I've also tried to figure out the right formula to use in order to identify reps and accounts where backdating has been done over multiple months with no luck. I think the best formula would be a countif formula for the first part, but each time I've written it, I either get an #N/A or an error message indicating my formula is incorrect. I haven't tried to figure out the formula for the 2nd part, because I've been stuck on the 1st part. Because I'm unable to attach anything, I've pasted an example of the output I'm trying to get based on the data within the pivot table. Any and all help is greatly appreciated. Thanks!
<TBODY>
</TBODY>
I've got a pivot that is providing me with the number of times a rep has backdated an account. I have been unable to find the right formula to capture any months where there has been backdating done multiple times within the same month. I've also tried to figure out the right formula to use in order to identify reps and accounts where backdating has been done over multiple months with no luck. I think the best formula would be a countif formula for the first part, but each time I've written it, I either get an #N/A or an error message indicating my formula is incorrect. I haven't tried to figure out the formula for the 2nd part, because I've been stuck on the 1st part. Because I'm unable to attach anything, I've pasted an example of the output I'm trying to get based on the data within the pivot table. Any and all help is greatly appreciated. Thanks!
Count of SubAcctNo</SPAN> | MONTH</SPAN> | ||||||||||
CSG_OpID</SPAN> | OP_NAME</SPAN> | SubAcctNo</SPAN> | 1-2015</SPAN> | 12-2014</SPAN> | 2-2015</SPAN> | 3-2015</SPAN> | 4-2015</SPAN> | Grand Total</SPAN> | Multiple Acct Activity per month</SPAN> | Monthly Adjustment Activity</SPAN> | |
MAY</SPAN> | Jane Doe</SPAN> | 1234567891234567</SPAN> | 2</SPAN> | 2</SPAN> | 1</SPAN> | FALSE</SPAN> | |||||
MAY</SPAN> | Jane Doe</SPAN> | 1234567891234568</SPAN> | 1</SPAN> | 1</SPAN> | FALSE</SPAN> | ||||||
MAY</SPAN> | Jane Doe</SPAN> | 1234567891234569</SPAN> | 1</SPAN> | 1</SPAN> | FALSE</SPAN> | ||||||
MAY</SPAN> | Jane Doe</SPAN> | 1234567891234561</SPAN> | 2</SPAN> | 2</SPAN> | 1</SPAN> | FALSE</SPAN> | |||||
MAY</SPAN> | Jane Doe</SPAN> | 1234567891234562</SPAN> | 2</SPAN> | 2</SPAN> | 1</SPAN> | FALSE</SPAN> | |||||
MAY</SPAN> | Jane Doe</SPAN> | 1234567891234563</SPAN> | 1</SPAN> | 1</SPAN> | 1</SPAN> | 3</SPAN> | TRUE</SPAN> | ||||
MAY</SPAN> | Jane Doe</SPAN> | 1234567891234564</SPAN> | 2</SPAN> | 1</SPAN> | 3</SPAN> | 1</SPAN> | TRUE</SPAN> | ||||
MAY</SPAN> | Jane Doe</SPAN> | 1234567891234565</SPAN> | 3</SPAN> | 1</SPAN> | 4</SPAN> | 1</SPAN> | TRUE</SPAN> | ||||
MAY</SPAN> | Jane Doe</SPAN> | 1234567891234566</SPAN> | 1</SPAN> | 1</SPAN> | FALSE</SPAN> | ||||||
MAY</SPAN> | Jane Doe</SPAN> | 1234567891234512</SPAN> | 1</SPAN> | 1</SPAN> | FALSE</SPAN> | ||||||
MAY</SPAN> | Jane Doe</SPAN> | 1234567891234513</SPAN> | 1</SPAN> | 1</SPAN> | FALSE</SPAN> | ||||||
MAY</SPAN> | Jane Doe</SPAN> | 1234567891234514</SPAN> | 1</SPAN> | 1</SPAN> | FALSE</SPAN> | ||||||
MAY</SPAN> | Jane Doe</SPAN> | 1234567891234515</SPAN> | 1</SPAN> | 1</SPAN> | FALSE</SPAN> | ||||||
MAY</SPAN> | Jane Doe</SPAN> | 1234567891234516</SPAN> | 1</SPAN> | 1</SPAN> | FALSE</SPAN> |
<TBODY>
</TBODY>