greekexcel
New Member
- Joined
- Oct 31, 2022
- Messages
- 32
- Office Version
- 2019
- Platform
- Windows
I have a table which look like this.
I want excel to understand each "SALES REP" as person.
For example to calculate all sales by KEVIN including the one with collaboration with other sales rep (KEVIN&JOHN) and split the Commission in half or 1/3 depending the situation
Also every time that i input 2 names in the same cell to can excel recognize them as individuals.
Thank you
I want excel to understand each "SALES REP" as person.
For example to calculate all sales by KEVIN including the one with collaboration with other sales rep (KEVIN&JOHN) and split the Commission in half or 1/3 depending the situation
Also every time that i input 2 names in the same cell to can excel recognize them as individuals.
Thank you