Afternoon All,
Hope someone can help me with this.
I'm looking to develop a formula that sorts the values of a column and returns the corresponding rows. See attachment.
I can easily sort a top 10 list which sorts the value and returns the Group and Type using this;
=INDEX(SORT($B$2:$D$11,3,-1,),ROW(1:10),{1,2,3})
However, how can I make it that I can match the groups and show the average age? e.g. Only show one line for Group C and the average age for all 3?
So I would essentially want a top 3 list for the Groups, as highlighted in yellow on the attachment.
Hope someone can help me with this.
I'm looking to develop a formula that sorts the values of a column and returns the corresponding rows. See attachment.
I can easily sort a top 10 list which sorts the value and returns the Group and Type using this;
=INDEX(SORT($B$2:$D$11,3,-1,),ROW(1:10),{1,2,3})
However, how can I make it that I can match the groups and show the average age? e.g. Only show one line for Group C and the average age for all 3?
So I would essentially want a top 3 list for the Groups, as highlighted in yellow on the attachment.