This is for a commissions report where I enter the sales rep who earns commissions on accounts they call on. Currently I am putting the accounts in ascending order and manually entering the sales rep. Is there a way that I can enter the account in one column and have the other column automatically recognize who it belongs to?
This question generated 7 answers. To proceed to the answers, click here.
This thread is current as of April 22, 2017.
For more resources for Microsoft Excel:
This article includes the following tags:
- Microsoft Excel