Help
Mike_Torrence
4 - Data Explorer
4 - Data Explorer
since ‎Feb 21, 2021
‎Nov 29, 2022

User Statistics

  • 3 Posts
  • 0 Solutions
  • 0 Kudos given
  • 0 Kudos received

User Activity

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]...