Forum Discussion
Golf
Check out the TAKE function
If you need more help:
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
This is a sample of what my spreadsheet looks like. I don’t know much at all how excel works. The far left number is the oldest. Would like for it to drop off when I add a new score on the far right.
NAME |
|
|
|
|
|
|
|
|
|
| Average |
|
Akers, Brian | 3 | 4 | 5 | 5 | 3 | 1 | 2 | 3 | 5 | 4 | 5 |
|
Alligood, Patrick | 27 | 22 | 32 | 33 | 28 | 19 | 33 | 33 | 29 | 22 | 33 |
|
Alliston, Bobby | 6 | 8 | 6 | 7 | 9 | 4 | 7 | 12 | 10 | 6 | 10 |
|
Amos, Warren | 22 | 16 | 13 | 23 | 16 | 14 | 28 | 16 | 16 | 11 | 22 |
|
Badenhorst, Wessel | 14 | 7 | 5 | 12 |
|
|
|
|
|
| 10 |
|
Barnes, Ron | 13 | 18 | 14 | 23 |
|
|
|
|
|
| 17 |
|
Bell, Shane | 16 | 21 | 11 | 13 | 18 | 24 | 9 | 11 | 10 | 12 | 20 |
|
Bennett, Brandon | 39 | 29 | 25 | 30 | 22 | 33 | 30 | 30 | 23 | 29 | 33 |
|
Bickley, Phil | 13 | 12 | 20 | 19 | 21 | 18 | 15 | 15 |
|
| 20 |
|
Bilbrey, Monty | 20 | 9 | 12 | 13 | 15 | 9 | 18 |
|
|
| 17 |
|
Biscoglia, Sonny | 8 | 9 | 8 | 14 | 5 |
|
|
|
|
| 10 |
|