L
Legacy 458280
Guest
Hi,
I have some data concerning supplier performance ratings and I'm looking for a formula to get an average 'Performance Rating' for each company within the last 90 days. I have done a fair amount of Googling but can't find a formula that performs the correct function.
The data is structured as follows (the first row of each sheet is used as headers):
Sheet 1 ("Individual Reviews"):
Column B - Date
Column E - Company
Column R - Performance Rating (%)
Sheet 2 ("Current Ratings"):
Column B - Company
Column C - Performance Rating (%)
Records are added manually into the 'Individual Reviews' sheet, with a formula to calculate the performance rating (for that specific record) as a percentage.
I'm looking for the 'Performance Rating' column in the 'Current Ratings' sheet to take an average (mean) of the performance ratings for all records in 'Individual Reviews' that match the company name given in each row in 'Current Ratings' within the last 90 days.
Any help would be greatly appreciated.
Many thanks,
Luke
I have some data concerning supplier performance ratings and I'm looking for a formula to get an average 'Performance Rating' for each company within the last 90 days. I have done a fair amount of Googling but can't find a formula that performs the correct function.
The data is structured as follows (the first row of each sheet is used as headers):
Sheet 1 ("Individual Reviews"):
Column B - Date
Column E - Company
Column R - Performance Rating (%)
Sheet 2 ("Current Ratings"):
Column B - Company
Column C - Performance Rating (%)
Records are added manually into the 'Individual Reviews' sheet, with a formula to calculate the performance rating (for that specific record) as a percentage.
I'm looking for the 'Performance Rating' column in the 'Current Ratings' sheet to take an average (mean) of the performance ratings for all records in 'Individual Reviews' that match the company name given in each row in 'Current Ratings' within the last 90 days.
Any help would be greatly appreciated.
Many thanks,
Luke