Hi There
I have a data set that contains dates, a manager name and a score (and additional information that isn't relevant). I'd like to create a formula that will summarise these results by month, manager name then average the scores.
Date Assessor COMPLIANCE
14-Aug-13 name 1 70
16-Aug-13 name 2 85
1-Jul-13 name 3 90
22-Aug-13 name 1 100
for example the Aug-13 average compliance score Name 1 is 85
I usually get around the date issue by creating a separate column, that vlookups to a month. But as i'm advancing in my knowledge, i'd like to elimate having to add this column and create a single formula
Thanks all
Bookmarks