Home >
Add-In Modules: General Excel Extensions
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. |