Hi all, I'm running Powerpivot in excel 2013 and have a table data whereby a list of people complete several tasks once per day, e.g.
Date | Day_ID | Person | Score1 | Score2 | Score3
08/02/14 | ND1 | Person1 | 10 | 20 | 20
08/02/14 | ND1 | Person2 | 13 | 16 | 21
08/02/14 | ND1 | Person3 | 7 | 26 | 31
01/02/14 | ND4 | Person1 | 15 | 21 | 23
01/02/14 | ND4 | Person2 | 25 | 16 | 21
01/02/14 | ND4 | Person3 | 65 | 21 | 14
I'm basically after calculating the individual average of each test for each Day_ID. For example Person1's average for Score1 on ND4 for the whole database (if that makes sense?). Any help greatly appreciated!
Date | Day_ID | Person | Score1 | Score2 | Score3
08/02/14 | ND1 | Person1 | 10 | 20 | 20
08/02/14 | ND1 | Person2 | 13 | 16 | 21
08/02/14 | ND1 | Person3 | 7 | 26 | 31
01/02/14 | ND4 | Person1 | 15 | 21 | 23
01/02/14 | ND4 | Person2 | 25 | 16 | 21
01/02/14 | ND4 | Person3 | 65 | 21 | 14
I'm basically after calculating the individual average of each test for each Day_ID. For example Person1's average for Score1 on ND4 for the whole database (if that makes sense?). Any help greatly appreciated!