LinkBack URL
About LinkBacks
In the attached WB, I would like RESULTS 1 Q3 to only calculate with a minimum of 10 results. I've tried the below w/o success. Note, this WB has reduced data, but should be enough for calculations.
Please Login or Register to view this content.
In the attached WB, I would like RESULTS 1 Q3 to only calculate with a minimum of 10 results. I've tried the below w/o success. Note, this WB has reduced data, but should be enough for calculations.
Please Login or Register to view this content.
Just my guess
Average of minimum of 10 results.
=AVERAGE(SMALL(IF(Table1[MAX GAIN]>=--RIGHT(Q$2,2),Table1[POINTS G/L]),ROW($A$1:INDEX($A$1:$A$10,MIN(10,COUNTIF(Table1[MAX GAIN],Q$2))))))
Thanks Bo_Ry, but that seems too complicated. I created my attempt from the formula in Q21. There must be a simpler method for this.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks