|
Ted is correct in solving this problem with the present version.
1. If your good at writing formulas just change it to reflect the last 20 races.
a. If so it won't delete the other information in the cells for that column unless you actually delete it.
b. Most need to delete much of their data collected anyway as its not current. I.e. thousand race data bases are insane anyway for one particular area. having a thousand race database is OK if broken down into smaller bytes such as by distance, surface and class.
2. If you can't write formulas just copy and paste into another workbook. That way you only need to get the formula correct one time, which should be attainable with help from others with real knowledgeable of this stuff or you fumble around to you get it right.(probably already done and there in the present day RDSS, unsure as I don't use it.
3. Use pencil and paper.
I have done a little work with Excel but I'm more a pencil and paper guy. The future updated version sounds like a vastly improved one over the present. For immediacy just work around it.
Mitch44
|