Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbered Lists
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare lists | Excel Worksheet Functions | |||
Capitalize Text if 2 lists are equal | New Users to Excel | |||
Excel - need a function to compare lists | Excel Worksheet Functions | |||
Numbered Lists! | Excel Discussion (Misc queries) | |||
Comparing 2 Customer Lists to Identify Shared Customers | Excel Worksheet Functions |