Home |
Search |
Today's Posts |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Long formulae
As far as I know the maximum length of a formula is 1024 characters. If you
need to fetch several cells from a separate spreadsheet which has a long path, then you better split your formula into several cells: - One cell in the current sheet for each cell you need to fetch; - One cell for the formula, using the cell references you just created. Not very elegant solution, but if anyone has something better to offer, feel free to contribute! Stephane Quenson. Yiannos wrote: Excel says that the formula I entered is too long... I have many spreadsheets with various data and I need the formulae to fet information from all my spreadsheets but it is too long... I have made a list of all my spreadsheet tab names... is it possible to have a short formula, with excel using this list of tab names? e.g. I have 3 spreadsheets 'A','B','C'. I need the sum of all A5 cells in each of the spreadsheets. The conventional formula will be: Sum(A!A5;b!A5;c!A5). If there are many spreadsheets with longer names and a morecomplicated function imagine how frustrating it can get! Is it possible to use one formula with variable spreadsheet instead of including the spreadsheet names in hte formula? Thank you -- Message posted via http://www.officekb.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Clearing cells takes long, long time | Excel Discussion (Misc queries) | |||
Long formulae | Excel Worksheet Functions | |||
Long formulae | Excel Worksheet Functions | |||
Long Date - Long Date = text is days | Excel Discussion (Misc queries) | |||
Searching TEXT in formulae, rather than results of formulae | Excel Worksheet Functions |