Hello, i’m trying to do a formula that gives me the average of scores from one column based on the group the individuals are in in another column. For example, let’s say I have 20 groups with four or five people in each of those groups designated in their column by their group number. In another column each of those individuals has a score, how would I then add up each of those scores for those in the same group and get the average for that group put into another column using a formula?
thank you!
thank you!