JJohnson07
New Member
- Joined
- Aug 28, 2017
- Messages
- 2
I am using Excel 10. If I have multiple reps that have scheduled visits, and the scheduled visits I want to track are identified with the numbers 2-51. How do I identify the missing visits according to the rep? I have found a few great VBAs for the missing numbers, have not found a solution tying the missing numbers to the rep's name. I would greatly appreciate any support! Below is an example of the data:
<tbody>
</tbody>
The output I need is as follows:
<tbody>
</tbody>
Reps | Visit |
Jim | 2 |
Jim | 3 |
Jim | 4 |
Jim | 6 |
Jim | 7 |
Beth | 2 |
Beth | 3 |
Beth | 4 |
Josh | 2 |
Josh | 5 |
Josh | 6 |
Josh | 7 |
<tbody>
</tbody>
The output I need is as follows:
Jim | 5 |
Josh | 3 |
Josh | 4 |
<tbody>
</tbody>