Did you see the latest entry at David Gainer’s blog? Formula Autocomplete.
Finally, it will be possible to write a SUBTOTAL formula without consulting the Help! But one of the commenters makes a good point about the SUBTOTAL function:
So… please help me understand why you’re using a function number rather than just the name of a function. When we’re skimming through a sheet, or looking at a print out of formula view, we’ll have to have learned which numbers refer to which functions, won’t we? Or am I missing the point completely?
Intellisense in the formula bar is a brilliant development! Very interested to see the new formulas, if any.
Mike
A meaningful string would be nice but it needs to stay a number for backward compatibility – otherwise open an Excel 12 wb in a previous version and subtotals would fail.
cheers
simon
“A meaningful string would be nice but it needs to stay a number for backward compatibility – otherwise open an Excel 12 wb in a previous version and subtotals would fail.”
yeah but when the work book was save in a old format excel could convert the formula!