Home >
Add-In Modules: General Excel Extensions Module
The following Add-in Functions are available:
| Function | Description | Use When |
|---|---|---|
| ExtendFormulaeToUsedRows | Extends formulae in a range to the specified area | Use when you wish to apply formulae to a dynamic row range |
| FormulaToDateColumn | Place the formula in the specified start cell and copies it to the used row range specified | Use when a calculated field is required alongside a set of source data whose number of rows is unknown |
| ReplaceFormulasWithValues | Replaces any formulas in the specified range with their resultant values | Use when you wish to break the links in a range so that the range becomes an independent range containing values only and no formulae |
| Union | Draws data from a set of named files in a specified directory and unions it into the specified destination sheet | Use when you wish to consolidate data from 2 different sources but containing comparable information |
| UnionValuesOnly | Draws data from a set of named files in a specified directory and unions it into the specified destination sheet. Only data is unioned (ie no formatting) | Use when you wish to consolidate data from 2 different sources but containing comparable information |
| UnZeroPivot | Hides Pivot items in a Pivot field based on a specified value in a specified column | Use when you wish to conditionally exclude Pivot items based on an amount field |
| Zeroingll | Hides or remove rows based on a specified columns value | Use when you wish to discard or hide insignificant rows of data |
| RemovePivotBlanks | Removes all the blank row items from the first Row Field in Pivot Table(s) on specified worksheet(s) | Use when you do not wish blank values to display in the rows of data in your Pivot Tables |
| HidePivotDataFieldCols | Hides columns in a worksheet with Pivot Tables based on the Pivot DataField SourceNames | Use when you wish to hide certain columns in a worksheet based on the SourceNames of the DataFields in the Pivot Table |
| ExcludePivotBlanks | Filters out (blank) Pivot Items in the specified PivotFields of a specified Pivot Table | Use when you want your Pivot Table to not be showing blank entries |