Hi guys,
I've been stuck on this issue for hours!
Basically, I've worked out how to average the top 5 values with the following:
=iferror(ArrayFormula(AVERAGE(large(if(Data!A:A=A2,Data!H:H),{1,2,3,4,5}))),0)
What I need to do is is average the top 25% of values in Data!H:H if the cells in Data!A:A match whats in A:A. For the life of me I can not figure it out.
Any help greatly appreciated!
Bookmarks