CycloneSteel
New Member
- Joined
- May 10, 2004
- Messages
- 11
OK -another golf spreadsheet question!
I want to take the most 6 recent weeks for handicap but having trouble with an efficient way to do that. It has to ignore any blank cells too. There will be 20-21 columns and want column B (A for name) to be a running most recent Handicap average of the most recent 6 weeks (in cells C-W for example). Input a new week for everyone in Cell G and want cell B to automatically update with the average. Seems simple enough but I can't for the life of me find a foolproof way. Most recent cell goes to the right of the previous entry.
Thanks!

Thanks!