G
glenlee
I have 2 Excel files:
1. File showing revenue by salesperson by month (1000 rows)
2. File showing salespeople that need to be removed from File #1 by
specific month. For example, this file would show Joe Salesperson,
June & August. Meaning I only want to exclude his revenue for those
specific months from File #1.
Anybody have a fast, easy way to accomplish this. Sorting and
Filtering is proving time-consuming and tedious. There's got to be an
easier way.
1. File showing revenue by salesperson by month (1000 rows)
2. File showing salespeople that need to be removed from File #1 by
specific month. For example, this file would show Joe Salesperson,
June & August. Meaning I only want to exclude his revenue for those
specific months from File #1.
Anybody have a fast, easy way to accomplish this. Sorting and
Filtering is proving time-consuming and tedious. There's got to be an
easier way.