vendredi 10 juillet 2020

Google Sheets - Finding the average of lowest 8 values from 20 most recent (rolling)

new to all this. Doing a golf spreadsheet and need to find out the average of lowest 8 rounds from the last 20 rounds. As I add in another scorecard, the calculation will move along etc.

Screenshot of spreadsheet

Any ideas on how I can get started? Thanks in advance

Aucun commentaire:

Enregistrer un commentaire