Skip to Content
0
Former Member
Feb 19, 2009 at 06:28 PM

Need help with combining groups on salesperson report

21 Views

I have a report that lists sales for salespeople by the name of the salesperson. In a couple of cases, the same salesperson has two "names", for example, John Smith and John Smith Z, which just groups that persons sales into two subgroups for different customers. There are only a few salespeople who have this situation. Is there a way to somehow do a formula that searches for "name like John Smith" and then set the name equal to "John Smith" (but the problem is this only happens a few times in the whole set of salespeople. Thanks!