The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
I’m looking for a formula that will return the smallest 8 of the last 20 items recorded. Here is the formula that I use in Excel to retrieve the information from a table:
=AVERAGE(SMALL(INDEX(Golfer[Index],ROWS(Golfer[Index])-20):INDEX(Golfer[Index]...