Quote:
Originally Posted by Tinkerman
Opening your 2 files in Open Office Calc, the first gives me the W-L records of the OL teams, which is great and plenty time saving enough. But the second is not producing the table, either just opening your file, or pasting in my own league data (with Record added under the last entry). I'm curious if you would know why that may be, but it's really not essential, so don't go to ANY trouble  .
|
The second uses Excel's SORT function. I'm not sure which version of Excel introduced that or whether Open Office has something similar which could substitute.
The alternative -- which is what I started to do before I discovered the SORT function -- is to simply map those cells to the hidden cells in the adjacent columns with absolute values, and then sort it manually. Hope that makes sense to you.