I have created a spreadsheet that formulates Numbered Lists as a Row
Identifier based on the location of the data within subsequent columns.
This works well, expect for two things:
1. Makes the Document too big. The complete spreadsheet is 16
Worksheets big and has increased in size to 23MB.
2. Too slow. Whenever a component is changed, the calculation time
slows down the process to a crawl.
To see one of the Worksheets see
http://users.cyberone.com.au/gdurham/NumberedLists.xls.
To see the formulae - Unhide Columns A through to R.
Can anyone offer any alternatives or nicer ways to do this.
Thanks,
Geoff.
Bookmarks