Paul Naylor
Board Regular
- Joined
- Sep 2, 2016
- Messages
- 98
- Office Version
- 365
- 2003 or older
- Platform
- Windows
- Mobile
- Web
Hi, hoping someone can help !
Got the following column data :
Column E - List of Sales Periods (P1 to P10) duplicate entries
Column O list of sales persons
Column BH - List of Quarterly sales figures
Thus for any given sales person there would be 4 entry per period i.e.
P1 , James Smith , £10,000
P1 , James Smith , £10,500
P1 , James Smith , £12,000
P1 , James Smith , £14,000
Trying to work out a formula that will display a list of each sales persons average sales for each Period (seperate table with Sales Persons names column A and Periods (P1-12) row 1.
Would point out that the raw data needs to be extracted from a seperate spreadsheet entitles "Raw Data"
Anyone any idea how to do ?
Got the following column data :
Column E - List of Sales Periods (P1 to P10) duplicate entries
Column O list of sales persons
Column BH - List of Quarterly sales figures
Thus for any given sales person there would be 4 entry per period i.e.
P1 , James Smith , £10,000
P1 , James Smith , £10,500
P1 , James Smith , £12,000
P1 , James Smith , £14,000
Trying to work out a formula that will display a list of each sales persons average sales for each Period (seperate table with Sales Persons names column A and Periods (P1-12) row 1.
Would point out that the raw data needs to be extracted from a seperate spreadsheet entitles "Raw Data"
Anyone any idea how to do ?