Documentation Excel

The FORMULATEXT function was officially introduced with Excel 2013, but thanks to Modern Functions Update (MFU) you can now run it on your Excel 2007 & 2010 versions. It works exactly as its original Microsoft counterpart. Description The FORMULATEXT function returns a formula as a text string from a referenced cell. This is extremely useful for: Syntax =FORMULATEXT(reference) Argument Description reference … Read more

AGGREGATE function was officially introduced with Office 2010, but thanks to MFU you can now run it on your 2007 version. It works exactly as its original MS counterpart. Description The AGGREGATE function returns the aggregate calculation (such as SUM, AVERAGE, MAX, MIN, etc.) from a list or database, with the option to ignore hidden rows and … Read more