CODEWITHSUNDEEP
excelexcel-formulaexcel-2010
Juan V
Juan V

Reputation: 61

creating a column of the average for groups of values in the same column in excel

This is a weird ask and sorry for butchering the title. On tableau, I am able to create a column for averages of a certain Tier. and I was wondering if there was a function that would do the same in excel. Here is an example of how I would like for it to look

enter image description here

Upvotes: 1

Views: 28

Answers (1)

Tom Sharpe
Tom Sharpe

Reputation: 34180

In Excel 2010

=AVERAGEIF(A$2:A$16,A2,B$2:B$16)

enter image description here

Upvotes: 1

Related Questions