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!