![]() You also need to link the product ID to the product category but only the first 4 digits of the product code relate to the product category. Then you need to summarize the sales by salesperson and calculate the commission to pay out. ![]() ![]() The system only outputs the sales person’s ID, so you need to add a new column to the data and use a VLOOKUP to get the salesperson associated with each ID. You then use the text to column feature to split out the data into new columns. Imagine you get a sales report in a text file from your system on a monthly basis that looks like this.Įvery month you need to go to the folder where the file is uploaded and open the file and copy the contents into Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |