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. P1Q1, P1Q2,P1Q3 & P1Q4 although.
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. P1Q1, P1Q2,P1Q3 & P1Q4 although.
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 ?