ShaunD30
Board Regular
- Joined
- Jun 19, 2008
- Messages
- 172
I am having a challenge with the data that is given to me..We have a system where 1 customer can have more than 1 sales consultant. Sometimes it is due to error..sometimes it is legit.
The problem I have is when I am reporting on the customers, I have to filter out the duplicates. The quick way is to simply do an advanced filter on unique values only. The problem with that is that the system automatically picks which account to filter out.
What can I do to get the filter to post all of the duplicates into 1 sheet so I can go through and view each sales consultant, and remove the account that does not apply?
Thank you,
Shaun
The problem I have is when I am reporting on the customers, I have to filter out the duplicates. The quick way is to simply do an advanced filter on unique values only. The problem with that is that the system automatically picks which account to filter out.
What can I do to get the filter to post all of the duplicates into 1 sheet so I can go through and view each sales consultant, and remove the account that does not apply?
Thank you,
Shaun